Excel 3-D Pie charts

Excel 365 2016 2013 2010 2007
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 2003

Do the following:

   1.   Select the data range (in this example A4:B9).

   2.   Select Insert -> Chart... to open the Chart Wizard dialog box:

Chart Wizard in Excel 2003

Choose the Pie type, the Pie with a 3-D visual effect sub-type and then click Next >.

   3.   In the Step 2 of Chart Wizard check the data and click the Next > button.

   4.   In the Step 3 of Chart Wizard, hide the legend in the Legend tab, in the Data Labels tab, choose the Category name and Value checkboxes and then click Next >.

   5.   In the Step 4 of Chart Wizard, click the Finish button.

   6.   Right-click in the chart area. In the popup menu select 3-D View...

   7.   In the 3-D View dialog box:

  • In Elevation type a number between 10 and 80. The default setting is 10 degrees.
  • In Rotation choose most suitable values of the chart orientation.
  • If you want to change the height of your chart, change the value in Height (% of base).
3-D View in Excel 2003

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.

Creating Pie of Pie and Bar of Pie charts

Creating Pie of Pie and Bar of Pie charts

If you have several parts of something whole, you can demonstrate each item in one pie chart. But, when several parts each amount to less than 10 percent of the pie, it becomes hard to distinguish the slices.
Using Pie Charts and Doughnut Charts in Excel

Using Pie Charts and Doughnut Charts in Excel

If you have several parts of something one, you can demonstrate each item in one pie chart. But sometimes you want to demonstrate the changes of those parts and doughnut chart will help you to do this.
Waterfall chart using Error bars

Waterfall chart using Error bars

The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. As we have shown Creating a Waterfall chart it can be created using a combination of Excel Bar charts. This tip will show you how streamline this process using Error Bar chart. The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values.