What-If Analysis, Charting, And Working With Large Worksheets Page 47
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 183
3
•
Click New sheet (Move
Chart dialog box) and
3-D Pie
then type
Chart
in the ‘New
sheet name’ text box
to enter a sheet tab
name for the chart
sheet.
•
Click the OK button
(Move Chart dialog
box) to move the
chart to a new chart
new sheet created
sheet with a new
with new name
sheet name, 3-D Pie
Chart in this case
(Figure 3 – 54).
Figure 3 –54
Other Ways
1. Select range to chart,
press
11
F
To Insert a Chart Title and Data Labels
The next step is to insert a chart title and labels that identify the slices. Before you can format a chart item,
such as the chart title or data labels, you must select it. The following steps insert a chart title, remove the legend,
and add data labels.
Chart Tools
1
Layout tab
•
Click anywhere in the
chart area outside
the chart to select
the chart.
Labels group
•
Display the Chart Tools
Layout tab and then
chart title
click the Chart Title
button (Chart Tools
Layout tab | Labels
group) to display the
Chart Title gallery.
•
Click the Centered
Overlay Title
command in the Chart
Title gallery to add a
chart title centered on
top of the chart.
•
Select the text in the
chart title and then
Six-Month
type
Financial
Projection
to
add a new chart title
Figure 3 –55
(Figure 3 – 55).
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education