Formatting a Chart

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

Changing the data series color

When a chart is created in Excel XP, you'll notice that color is automatically applied to the data series. You can keep this format or change it for each data series in the chart. Various aspects of each data series can be changed, but you'll probably 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.

    Data Series Color Selection
  • Click Format on the Chart toolbar, or double-click the data series.

    Chart Toolbar
  • Use the Format Data Series dialog box to select a new color.

    Format Data Series Dialog Box
  • Click OK to accept the data series color changes.