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