Excel 3-D Pie charts

Excel 2016 2013 2010 2007 2003
This tip is about how to create a pie chart such as in popular glossy magazines.

If you want to create a pie chart that shows your company (in this example - Company B) in the greatest positive light:

Pie Chart in Excel 365

Do the following:

   1.   Select the data range (in this example, B3:C8).

   2.   On the Insert tab, in the Charts group, choose the Pie button:

Pie Chart in Excel 365

Choose the 3-D Pie 3D Pie in Excel 365 chart.

   3.   Right-click in the chart area, then select Add Data Labels and click Add Data Labels in the popup menu:

Add Data Label in Excel 365

   4.   Click in one of the labels to select all of them, then right-click and select Format Data Labels... in the popup menu.

   5.   On the Format Data Labels pane, in the Label Options tab, select the Category Name checkbox:

Format Data Labels in Excel 365

   6.   Right-click in the data series and select Format Data Series... in the popup menu:

Format data series in popup menu Excel 365

   7.   On the Format Data Series pane:

  • In the Series Options tab:
    • In the Angle of first slice field, move the sliding handle to the rotation degree that you want, or type a number between 0 and 360 degrees. The default setting is 0 degrees.
    • In the Pie Explosion field, move the sliding handle to the percentage of the explosion that you want, or type a percentage between 0 and 400 in the text box. The default setting is 0%.
    Format Data Series in Excel 365
  • In the Effects tab, in the 3-D Format group, make changes you want.

   8.   Right-click in the plot area and select Format Plot Area... in the popup menu.

   9.   On the Format Plot Area pane, in the Effects tab, in the 3-D Rotation group, choose the appropriate value for the Perspective field:

Format Plot Area in Excel 365

You can then make any other adjustments to get the look you desire.

See also this tip in French: Graphiques à secteurs 3-D.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more