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.

Changing the color of a data series

You can apply formatting to each data series of a chart. Although you can change different aspects of each data series, you will probably find that you change the color of bars, columns, pie slices, and areas most often.

To change the color of a data series:

  • Select the data series you want to edit.

    select data series

  • Click the format button format button on the Chart toolbar, or double-click the data series.
  • Use the Format Data Series dialog box to pick a new color.

    format data sereis dialog box

  • Click OK.

Your chart should display the new colors.

chart with different colors