If your category labels are too long to fit inside your pie chart, switch the label position to the outside. Just click on the chart box, and then select “No Outline.” What if your pie chart category labels are too long? If you plan to copy this chart into another type of document, I suggest taking away the random chart outline Excel puts in by default. So in my case, the darkest red, the second darkest gray/blue, and the third darkest gray/blue. If you think this might get printed in black and white, I suggest pulling the 3 colors from different color rows. Then I’ll draw from a gray scale for the other two segments. I’ll use a strong color (say red) for the highlight. I like using a highlight color when possible (especially when I am going to discuss the chart in the body of a text). I also want to change the pie chart colors off the default. While I have the data labels selected, I’m going to move to the top of the page and change the font, font size, and data label color. I’m also going to unclick the “Value” box and click on the “Percentage” box. In the same Format Data Labels menu as the previous step, just click on the Category Name box. I also want to add the category name to the label. Adding the Category Name to the Data Label Just right click on the label and select “Format Data Labels” to bring up the menu. I don’t like Excel’s “Best Fit” so I’m going to change the label position. You do this by right clicking on the pie chart and selecting “Add Data Labels” from the menu. So I’m going to delete that (click on the legend and press the delete button) and then directly label the pie chart portions. I’ll just pretend my data is real and not fake. Lots of pie charts are created using percentages that add up to 100. So in addition to just a column of numbers it’s a good idea to have row labels and column headers. Here are some more steps you probably want to take to create something worth sharing. Okay, so that’s the most basic of basics.
#CAN MAKE A PIE CHART IN EXCEL HOW TO#
Woohoo, you created a pie chart! How to create a good looking pie chart. *If you have any instinct to click the 3-D Pie button, resist that instinct. Click on the insert tab, then the pie chart icon. It just takes a column of data and a couple of buttons. When to use a pie chart (and when not to use a pie chart).Ĭreating a pie chart (a.k.a.How to create a good looking pie chart.Today we’ll go with a chart that is widely used but often maligned by chart experts, the Pie Chart. In each post we will take on a different chart type.
#CAN MAKE A PIE CHART IN EXCEL SERIES#
This is the fourth in a series of posts on chart design in Excel.
0 kommentar(er)
