We see in Figure 5-22 that the Chart data range, =??™Sales By Category??™!$A$2:$C$5, is correct,
and we do not want to switch the row/column orientation. We need to correct the
legend information display, and we want to use the category information to add a title
to the chart.
8. In the Legend Entries (Series) section, at the bottom left of the Select Data Source
dialog box, select Series 1 from the list.
9. Click the Edit button to display the Edit Series dialog box (shown in Figure 5-23).
CHAPTER 5 n CHARTING IN EXCEL 2007 208
Figure 5-23. The Edit Series dialog box
10. To add the title, in the Series name text box, type =??™Sales By Category??™!$A$2 (or use the
range selector to navigate to cell A2 and let Excel insert the range reference for you).
Figure 5-24 shows the Edit Series dialog box with this value entered.
Figure 5-24. Series name range reference added to the Edit Series dialog box
11. Click OK to store the range reference.
12. In the Horizontal (Category) Axis Labels section, at the bottom right of the Select Data
Source dialog box, click the Edit button to show the Axis Labels dialog box, as shown in
Figure 5-25 (no selection is necessary).
Figure 5-25. The Axis Labels dialog box
13. In the ???Axis label range??? text box, type in =??™Sales By Category??™!$B$2:$B$5 to tell Excel
to show only the month names in the legend (or use the range selector to select cells
B2:B5 and let Excel insert the range reference for you).
14. Click OK to store the range reference.
Pages:
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207