Excel 3-D Pie charts

Excel 365 2016 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 A) in the greatest positive light:

Pie Chart in Excel 2013

Do the following:

   1.   Select the data range (in this example B5:C10).

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

Charts in Excel 2013

Choose 3-D Pie.

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

popup menu in Excel 2013

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

popup menu in Excel 2013

   5.   In Format Data Labels opened in the Format task pane, on the Label Options tab, select the Category Name checkbox:

Format Data Labels in Excel 2013

   6.   Open Format Data Series in the Format task pane:

  • In the Series Options section:
    • In the Angle of first slice 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 move the sliding handle to the percentage of 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 2013
  • In the Effects section, in the 3-D Format group make changes you want.

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

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.