Modifying the Pie Chart Design
Although the chart created in the last section might work just fine for your needs, many times you’ll want to make a few design changes, depending on what type of point you’re trying to make with your data. To do this, make sure the pie chart is selected and then open the Design tab under Chart Tools on the Excel ribbon.
If you expand the Chart Layouts category, you’ll see several different ways to present the data on your chart. You can choose to have the amounts represented as a percentage of a whole, show labels on the chart rather than on a legend, show the original data, or any combination of these items.
For this example, we’ll choose Layout 4 which gets rid of the legend and shows the labels on the pie chart along with the original data.
There are many other options you can select to modify the formatting of both your data and chart, but we’ll dive deeper into those a little later on in this series.
One thing that I don’t like about using this particular layout with our example data is that some of the smaller portions don’t stand out very well in the pie chart. This can be fixed, however, if we break out those portions into a “sub" pie chart. We’ll talk more about how to do that in Part 3 of this series.