How to Modify Chart Data in Excel
Once you see data in a chart, you may find there are some tweaks and changes that need to be made. Here are a few ways to change the data in your chart.
If you need to add additional data from the spreadsheet to the chart after it’s created, you can adjust the source data area.
The new data needs to be in cells adjacent to the existing chart data.
Charts are not completely tied to the source data. You can change the name and values of a data series without changing the data in the worksheet.
The name is updated in the chart, but the worksheet data remains unchanged.
You can also change the order of data in the chart without changing the order of the source data.
The chart is updated to display the new order of data, but the worksheet data remains unchanged.
Free to distribute with our compliments; we hope you will consider our paid training.