Microsoft Office Tutorials and References
In Depth Information
Changing Pie Slice Colors
3. Click Number in the list on the left side of the dialog box. The options related to
number formats appear in the dialog box.
4. Click Percentage in the Category box, and then verify that appears in the 2
Decimal places box. The percentage values for each slice show two decimal places
for more accuracy.
5. Click the Close button. The data labels appear as percentages on the outer edges
of the slices. Note that leader lines don’t appear in the pie chart because the chart
area has enough space to place the labels close to their slices. See Figure 4-12.
Figure 4-12
Formatted data labels
data labels appear
as percentages
outside of each slice
Changing Pie Slice Colors
Pie slice colors should be as distinct as possible to avoid confusion. Using distinct
colors is especially important for adjacent slices. Depending on the printer quality or the
monitor resolution, similarly colored slices might be diffi cult to distinguish in the fi nal
report. You can change the colors used for each slice. Because each slice in a pie chart
represents a different value in the series, you must format each slice rather than the entire
data series.
In the assets pie chart, the slices for Cash, Bonds, and Other have similar colors. You’ll
change the fi ll color of the Other and Cash slices.
To select and format pie slices in the assets pie chart:
1. Click the pie to select the entire data series.
2. Click the light blue Other slice, which represents 3.97 percent of the pie. Only
that value, or slice, is selected.
3. Click the Home tab on the Ribbon.
4. In the Font group, click the Fill Color button arrow , and then click Yellow
(the fourth color in the Standard Colors section). The Other slice and legend
marker change to yellow.
5. Click the dark blue Cash slice, which covers 8.44 percent of the pie.
Search JabSto ::

Custom Search