What-If Analysis, Charting, And Working With Large Worksheets Page 71
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
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 207
Figure 3 – 85
5. Select cell K19. Drag the fi ll handle in to the center of cell K19 so that the cell is shaded and the
cell contents are deleted.
6. Apply a worksheet name to the sheet tab and apply a color of your choice to the sheet tab.
7. Select cell range H2:I14, click the Pie button (Insert tab | Charts group) to display the Pie gallery,
click Pie in 3-D chart in the Pie gallery, click the Move Chart button (Chart Tools Design tab |
Location group), click the New sheet option button (Move Chart dialog box), and then click the
OK button (Move Chart dialog box) to move the 3-D Pie chart to a new worksheet.
8. Click the Chart Title button (Chart Tools Layout tab | Labels group), click Above Chart in the
Chart Title gallery, select the title, and change the chart title to “Yearly Breakdown”.
9. Click the Data Labels button (Chart Tools Layout tab | Labels group), click Outside End in the
Data Labels gallery to add data points to the chart.
10. Apply a chart sheet name to the sheet tab and apply a color of your choice to the tab.
11. Change the document properties, as specifi ed by your instructor. Change the worksheet header
with your name, course number, and other information as specifi ed by your instructor. Save
the workbook using the fi le name, Extend 3-1 Create Series Complete Part 2, and submit the
workbook as specifi ed by your instructor.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education