This course is designed better than some classes I’ve taken in school.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2000

Single page view print copy

Editing Charts

Formatting the Chart Legend

The chart legend displays very useful information. Be sure to format the legend so that it is as clear as possible.

chart title format dialog box

To Format the Chart Legend:

  • If the legend is not showing press the show/hide legend button legend buttonon the Chart Toolbar.
  • Click on the Chart Legend.
  • Click the Format Button format button on the Chart Toolbar (or double click the chart legend).
  • Use the different tabs of the Format Chart Legend dialog box to apply formatting to the Legend.
  • Click OK.

    chart title format dialog box

Important Point The only way to change the actual text of the legend is to make changes to the source data.

1 2 3 4 5 6 7 8