Editing Charts

Excel charts let you illustrate your workbook data graphically to see trends. Learn how to edit charts in Excel in this free lesson.

Formatting the chart legend

The chart legend displays useful information. Be sure to format the legend so 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 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.