You can choose any angle to rotate the slices in the pie chart in a clockwise rotation. TIP: As you hover over each choice in the drop down menu, it will show you a preview of your data in the highlighted chart format. To rotate the slices in the chart, simply right click anywhere on the pie chart and then click Format Data Series…Ī new window will pop up on the right side of the screen with a slider bar that allows you to choose the Angle of first slice. Highlight one slice in the Pie Chart: To do this, uncheck the ‘Vary colors by slice. The following formatting options are available: Fill & Line Effects Series Options Now let me show you some minor formatting that you can do to make your Pie chart look better and more useful for the reader. Pie charts are meant to express a part to whole relationship, where all pieces together represent 100. This will open a pane (or a dialog box) with all the series formatting options. The Pie Chart is a primary chart type in Excel. Suppose we have the following pie chart in Excel that shows the total sales by quarter for a particular company: To format the series, right-click on any of the slices of the Pie chart and click on ‘Format Data Series’. Pie of Pie chart in Excel Step 1 : Select the data, click Insert tab > chose pie chart ribbon >Pie of pie chart as shown below.
Example: Rotate the Slices of a Pie Chart Lets see how to create Pie of Pie chart in Excel. As an example, we would be using the 2D Pie. Select from the 2D Pie, 3D Pie, or the Doughnut shaped charts. Click on the Pie Chart icon under the Charts section. Then select all the data and head over to the Insert tab. A pie chart is a type of chart that is shaped like a circle and uses “slices” to represent proportions of a whole.įortunately it’s easy to create a pie chart in Excel, but occasionally you may want to rotate the individual slices of the chart in a certain direction. Input the required data in your Excel spreadsheet.