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.
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.