Chapter 21: Using Advanced Charting Techniques
21
If you move a legend manually, you may need to adjust the size of the chart’s Plot Area.
The quickest way to remove a legend is to select it and then press Delete.You can select individual items within a legend and format them separately. For example,
you may want to make the text bold to draw attention to a particular data series. To select
an element in the legend, first select the legend and then click the desired element.If you didn’t include legend text when you originally selected the cells to create the chart,
Excel displays Series 1, Series 2, and so on, in the legend. To add series names, choose
Chart Tools ➪ Design ➪ Data ➪ Select Data to display the Select Data Source dialog box
(see Figure 21.7). Select the series name, and click the Edit button. In the Edit Series dialog
box, type the series name or enter a cell reference that contains the series name. Repeat for
each series that needs to be named.FIGURE 21.7
Use the Select Data Source dialog box to change the name of a data series.In some cases, you may prefer to omit the legend and use callouts to identify the data
series. Figure 21.8 shows a chart with no legend. Instead, it uses shapes to identify each
series. These shapes are from the Callouts section of the Chart Tools ➪ Format ➪ Insert
Shapes gallery.