What-If Analysis, Charting, And Working With Large Worksheets Page 56
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 192
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Change the Colors of the Remaining Slices
Exploding a 3-D
The colors of the remaining slices also can be changed to enhance the appeal of
Pie Chart
the chart. The following steps change the color of the remaining fi ve chart slices.
If you click a 3-D Pie chart
so that all of the slices are
1
Right-click the slice labeled July to select only the July slice, and display a shortcut menu
selected, you can drag one
and Mini toolbar.
of the slices to explode all
of the slices.
2
Click the Shape Fill button arrow on the Mini toolbar to display the Color gallery.
3
Click the Yellow color in the Standard Colors area in the Color gallery to change the color
of the slice.
4
Repeat Steps 1 through 3 for the remaining four slices. Assign the following colors in the
Standard Colors area in the color gallery to each slice: September – Green; October – Dark
Blue; November – Red; December – Purple.
5
Click anywhere outside the chart to deselect the December slice (Figure 3– 71).
The completed chart appears as shown in Figure 3– 71.
slice colors
changed
Figure 3 –71
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education