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. 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.
This is the fourth in a series of posts on chart design in Excel.
0 kommentar(er)
