Forum Discussion
John_Dickson
Jan 01, 2022Copper Contributor
Excel - adding new data points to an existing chart
I am trying to add data points to an existing chart. The new data has been added to the table in the related spreadsheet. When I right-click on one of the three series shown in my chart and then ch...
NowshadAhmed
Jan 02, 2022Iron Contributor
Instead of right clicking a data series, right click on the chart and choose select data. This will show all the available data sources. You do any of the following:
1. Re-specify the entire data to be charted in the 'Chart data range' box.
2. In the legen entry section click on 'Add'.
Note on the series values in the Edit Series window: it is best to clear the contents before selecting new data.
1. Re-specify the entire data to be charted in the 'Chart data range' box.
2. In the legen entry section click on 'Add'.
Note on the series values in the Edit Series window: it is best to clear the contents before selecting new data.
- John_DicksonJan 05, 2022Copper ContributorThank you for your advice, Nowshad Ahmed. Exactly what I was looking for. (Simple when you know how!)