#3D PIE CHARTS IN EXCEL 2013 HOW TO#
Find out how to make a table in Excel so that you can easily sort, filter, and format the data in your spreadsheet. One other useful way to sort and organize data in Excel is with a table. If you need to use your pie chart in another Microsoft Office application like Microsoft Word or Microsoft Powerpoint then you can right-click on the chart and choose the Copy option, then simply paste it into the desired document. Choosing the Layout tab provides you with ways to add some needed chart options to the chart, such as labels for your x axis and y axis, you can format data labels, and you can even edit the chart title. If you click the chart you will see a Design tab and a Layout tab at the top of the window. In the popup menu select Add Data Labels and then click Add Data Labels : 4. On the Insert tab, in the Charts group, choose the Pie button: Choose 3-D Pie. If you choose one of the corner circles then it will expand the chart while keeping everything at scale. Select the data range (in this example B5:C10 ). Your chart is going to have some circles on its border that you can drag if you want to make the chart taller or wider. Some of the other pie charts available after clicking the More Pie Charts menu include “Pie of Pie” and “Bar of Pie.” The layout of these charts will split some of the smaller pie slices from the main pie chart and show that as their own pie chart next to it. Each party has its own color, making it easy to identify it in the pie. I selected the 3-D pie chart called Exploded Pie in 3D and created this: You can see the size of each piece of data quite clearly. If you need to use a pie chart other than the ones that are shown on the pie chart drop down menu then you can click the More Pie Charts button at the bottom of that menu. Select the data, including the headings, and click Insert, Charts, Pie, and select a chart type. These different chart options are visible when you click the pie button in the Charts group on the ribbon.
![3d pie charts in excel 2013 3d pie charts in excel 2013](https://peltiertech.com/images/2010-02/pie3Dorig.png)
![3d pie charts in excel 2013 3d pie charts in excel 2013](https://www.officetooltips.com/images/tips/207_365/1.png)
Excel offers a handful of various 2D pie chart options, as well as a 3D pie chart option and a doughnut chart option.