In most cases, setting the percentage threshold is the most reasonable choice, but everything depends on your source data and personal preferences. The following screenshot demonstrates splitting the data series by Percentage value :. If you have more than one data series that relate to the whole, you can use a doughnut chart instead of a pie chart. However, in doughnut charts, it's hard to estimate proportions between elements in different series, and that is why it makes sense to use other chart types instead, such as a bar chart or column chart.
When creating doughnut charts in Excel, the first thing you might want to change is the hole size. And you can easily do this in the following way:. If you create a pie chart in Excel only to have a quick look on certain trends in your data, the default chart might suffice. But if you need a beautiful graph for presentation or similar purposes, you may want to make some improvements and add a few finishing touches. Adding data labels make Excel pie graphs easier to understand.
Without labels, it would be difficult to deduce the exact percentage of each slice. Depending on what you want to highlight on your pie chart, you can add labels to the entire data series or individual data points, as demonstrated in Adding data labels to an Excel chart. In this pie chart example, we are going to add labels to all data points. Additionally, you may want to change the Excel pie chart labels location by clicking the arrow next to Data Labels. Compared to other Excel graphs, pie charts provide the biggest choice of label locations:.
If you want to show the data labels inside bubble shapes , select Data Callout :. If your Excel pie graph has more than three slices, you may want to label them directly rather than force your users to go back and forth between the legend and the pie to find out what each slice is about. Layouts 1 and 4 are the ones with data category labels:. For more options, click the Chart Elements button green cross at the upper-right corner of your pie chart, click the arrow next to Data Labels , and choose More options… from the context menu.
Add a pie chart - Office Support
This will open the Format Data Labels pane on the right side of your worksheet. Switch to the Label Options tab, and select the Category Name box. If your source data are numbers , then you can configure the data labels to display either original values or percentages, or both.
To emphasize individual values in your Excel pie chart, you can "explode" it, i. Or, you can add emphasis to individual slices by pulling them out from the rest of the pie graph. Exploded pie charts in Excel can be displayed in 2-D and 3-D formats, and you can also explode doughnut graphs:. The quickest way to explode the entire pie chart in Excel is to click it so that all of the slices get selected , and then drag them away from the center of the chart using the mouse. To draw your users' attention to a certain slice of a pie, you can move it out from the rest of the pie chart.
And again, the quickest way to pull out an individual slice is to select it and drag away from the center using the mouse. To select a single slice, click on it, and then click it again so that only this slice is selected. Alternatively, you can select the slice you want to move out, right-click it, and select Format Data Series from the context menu. When creating a pie chart in Excel, the plot order of the data categories is determined by the data order on your worksheet. However, you can rotate your pie graph within the degrees of the circle for different perspectives.
Generally, Excel pie charts look better with the smaller slices at the front. For 3-D pie charts in Excel, more rotation options are available. To access the 3-D rotation features, right click any slice and select 3-D Rotation This will bring up the Format Chart Area pane, where you can configure the following 3-D Rotations options:.
How to Create a Chart in Excel Using Shortcut Keys
When you click the up and down arrows in the rotation boxes, your Excel pie chart will rotate immediately to reflect the changes. So you can keep clicking the arrows to shift the pie in small increments until it is in the right position. For more rotation features, please see the following tutorial: How to rotate charts in Excel. As a general rule, pie charts are easier to understand when slices are sorted from largest to smallest. The fastest way to do this is to sort the source data on the worksheet.
Add a pie chart
If sorting the source data is not the option, you can rearrange the slices in your Excel pie chart in the following way. As you can see in the screenshot above, the choice of color themes for Excel charts is quite limited, and if you are aiming to make a stylish and attractive pie graph, you may want to choose each slice color individually. For example, if you've chosen to place data labels inside the slices, the black text may be difficult to read on dark colors.
To change the color of a certain slice, click that slice and then click it again so that only this one slice is selected. Go to the Format tab, click Shape Fill and choose the color you want:. When you build a pie chart in Excel for presentation or exporting to other applications, you may want to give it a polished eye-catching look. To access the formatting features, right-click any slice of your Excel pie chart and select Format Data Series from the context menu.
The Format Data Series pane will appear on the right of your worksheet, you switch to the Effects tab the second one and play with different Shadow , Glow and Soft Edges options. To use these formatting features, select the element of your pie graph that you want to format e. The relevant formatting features will get activated, and non-relevant ones will be greyed out.
Now that you know how to do a pie chart in Excel, let's try to compile a list of most essential do's and don'ts to make your pie graphs both meaningful and good-looking. This is how you make pie charts in Excel. In the next part of Excel charts tutorial, we will dwell on making bar charts. Thank you for reading and see you next week!
Many thanks for this tutorial. It did help me achieve what i have been trying how to do on my own.
I have several pie charts with the same row labels but different percentages depending upon division. I used a pivot table to create my pie chart.
- google sync outlook 2016 mac.
- mac os vs linux ubuntu.
- How to Make an Excel Chart in Office 2011 for Mac.
On this chart, communication shows as red and policy as blue. I have 10 divisions to pivot chart from one set of data. E-mail not published. How to make pie chart in Excel How to create different pie chart types 2-D pie charts 3-D pie charts Pie of Pie and Bar of Pie charts Doughnut charts Customizing an Excel pie graph Adding data labels Exploding a pie chart Rotating a pie chart Sorting slices by size Changing a pie graph colors Formatting a pie chart Excel pie chart tips How to make a pie chart in Excel Creating a pie chart in Excel is extremely easy, and takes nothing more than a couple of button clicks.
- paragon software group ntfs mac;
- Popular Topics;
- Customizing the Pie Chart.
- go to end of line on mac;
- Steps to Create a Pie Chart.
- half life 3 for mac!
Prepare the source data for the pie chart. In general, an Excel pie chart looks best when: Only one data series is plotted in the chart.
All data values are greater than zero. There are no empty rows or columns. There are no more than 7 - 9 data categories, because too many pie slices can clutter your chart and make it difficult to understand. For this Excel chart pie tutorial, we are going to make a pie graph from the following data: 2. Insert a pie chart in the current worksheet. In this example, we are creating the most common 2-D pie chart: Tip.
If you've chosen to put the labels inside slices, the default black text may be difficult to read on dark slices like the dark blue slice in the pie chart above. Alternatively, you can change the color of individual pie chart slices. Now that you've added the data labels to your Excel pie chart, the legend has become redundant and you can remove it by clicking the Chart Elements button and unchecking the Legend box. If you want to pull out several slices, you will have to repeat the process for each slice individually, as shown in the screenshot above.
Select the data you want to use in the chart. Here's how to add a chart to the same worksheet:. Press the F1 key. Now, a new chart is created and added to your current worksheet, alongside your data. Here's how to change the chart type:. Select the chart. Select the Chart Tools Design tab. Select Change Chart Type. Select the type of chart you would like to use. Select the style of the chart. Select OK when you're done. Follow these steps to save your new chart template:. Enter a name for the template in the File name text box. To delete a chart template:. Select Templates to see a list of your chart templates.
Right-click on the chart template you want to delete and select Delete. Continue Reading.