What-If Analysis, Charting, And Working With Large Worksheets Page 50
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 186
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
6
•
Click the Close button
to close the Format
Data Labels dialog box
and display the chart
3-D Rotation
(Figure 3 – 60).
button
data labels
selected
data labels include
category name
and percentage
Figure 3 – 60
To Rotate the 3-D Pie Chart
With a three-dimensional chart, you can change the view to better show the section of the chart you are trying
to emphasize. Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes.
When Excel initially draws a Pie chart, it always positions the chart so that one of the dividing lines between
two slices is a straight line pointing to 12 o’clock (or 0°). As shown in Figure 3 –60, the line that divides the
December and July slices currently is set to 0°. This line defi nes the rotation angle of the 3-D Pie chart.
To obtain a better view of the offset August slice, the largest slice, the 3-D Pie chart can be rotated 90° to
the left. The following steps rotate the 3-D Pie chart.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education