Sunday, October 15, 2017

Rotate a pie chart

Rotate a pie chart

To change how the slices in a pie chart are arranged, you rotate it. You can do this with pie, 3-D pie, and doughnut charts in Microsoft Excel, or with an Excel chart you've copied to PowerPoint, Word, or Outlook.

For example, in this chart, a couple of the state labels are wedged in under the title. Shifting the pie clockwise can fix that, and also reposition California to emphasize how big a piece of the pie its population is compared to the other four states. As a bonus, California's label becomes more visible. So, let's shift the pie clockwise one third of a circle, or 120 degrees.

  1. Right-click any slice of the pie chart > Format Data Series.


    Before rotating pie slices

  2. In the Format Data Point pane in the Angle of first slice box, replace 0 with 120 and press Enter.


    Change Angle of first slice

    Now, the pie chart looks like this:

    After rotating pie slices

If you want to rotate another type of chart, such as a bar or column chart, you simply change the chart type to the style that you want. For example, to rotate a column chart, you would change it to a bar chart. Select the chart, click the Chart Tools Design tab, and then click Change Chart Type.

Change Chart Type

See Also

Add a pie chart

Available chart types in Office

Change axis labels in a chart

No comments:

Post a Comment