Forum Discussion
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...
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.
Thank you for your advice, Nowshad Ahmed. Exactly what I was looking for. (Simple when you know how!)