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?
Where do I go from here?