What-If Analysis, Charting, And Working With Large Worksheets Page 46
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 182
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Draw a 3-D Pie Chart on a Separate Chart Sheet
The following steps draw the 3-D Pie chart on a separate chart sheet.
1
Insert tab
•
Pie button
Select the range B12:G12 to identify
the range of the category name of
the 3-D Pie Chart.
•
If necessary, scroll the worksheet so
that row 25 is displayed, and while
holding down the
key, select
CTRL
the range B25:G25.
Pie gallery
•
Display the Insert tab.
•
3-D Pie chart
Click the Pie button (Insert tab |
Charts group) to display the Pie
gallery (Figure 3 –52).
Figure 3 –52
Chart Tools
2
Design tab
Move Chart button
•
Click Pie in 3-D chart in the Pie
gallery to select the desired chart
type.
•
When Excel draws the chart, click
the Move Chart button (Chart Tools
Design tab | Location group) to
Move Chart
Location
dialog box
display the Move Chart dialog box
group
(Figure 3 – 53).
New sheet
option button
New sheet name box
OK button
Figure 3 –53
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education