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

When you add a chart to your worksheet, Excel creates a link between the chart and your source data. Any changes made to the original source data are automatically reflected in the chart.

Edit Data Source

To change chart values directly in worksheet cells:

  • Open the worksheet that contains the chart to be changed.
  • Click in the cell whose value will change, and type the new value.
  • Press Enter to accept the new value.