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 data in a chart

When you add a chart to your worksheet, Excel creates a link between the chart and your source data. This way, any changes you make to the original source data are instantly reflected in your chart.

You can also add rows or columns of data to an existing chart by selecting Add Data on the Chart menu.

To add data to an existing chart:

  • Select the chart you want to edit.
  • Choose ChartAdd Data.

    chart menu

  • Enter the range you want to add in the Add Data dialog box, or select the range of cells you want to add to your chart.
  • Click OK.

    add data dialog box

Your chart should update to display the new data.

chart with two data sets