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...
If you left-click on a series, do you see a formula in the formula bar of the form
=SERIES("Data",Sheet1!$A$1:$A$12,Sheet1!$B$1:$B$12,1)
In this example, Sheet1!$A$1:$A$12 is the x-values range, and Sheet1!$B$1:$B$12 is the y-values range.
If I wanted to include cells in rows 13 to 15 in the series, I'd edit the formula to
=SERIES("Data",Sheet1!$A$1:$A$15,Sheet1!$B$1:$B$15,1)
- Many thanks for your response to my question, Hans. Your solution is what I have been doing previously. However, perversely, the "Select Data Source" window is not displaying the data ranges for the "x" and "y" axes but instead states that "the data range is too complex to be displayed.
Where do I go from here?I meant clicking on a series on the chart itself. That way, you don't have to use the Select Data Source dialog.
Thank you, Hans. Right-clicking on the chart itself, rather than the actual plot, seems to be the answer. Your advice is much appreciated.
