What-If Analysis, Charting, And Working With Large Worksheets Page 49
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 185
Chart Tools
4
Layout tab
Data Labels button
•
Click the None Legend
option in the Legend
gallery to turn off the
legend on the chart.
•
Click the Data Labels
button (Layout tab |
Labels group) and
Labels
group
then click Outside
End in the Data
Labels gallery to
display data labels
outside the chart at
the end of each slice
legend no
longer is
(Figure 3 – 58).
displayed
Figure 3 – 58
5
•
If necessary, right-
Format Data Labels
dialog box
click any data label
to select all of the
data labels on the
chart and to display a
shortcut menu.
Series Name
check box
•
Click the Format Data
Value check box
Labels command on
Percentage
Category Name
the shortcut menu to
check box
check box
display the Format
Data Labels dialog box.
•
If necessary, click the
Series Name, Value,
and Show Leader Lines
check boxes to deselect
data labels
selected
them (Format Data
Labels dialog box) and
then click the Category
Name and Percentage
Close button
check boxes to cause
the data labels to
be displayed with
category names and
percent values, rather
than currency values
(Figure 3–59).
Figure 3 – 59
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education