Dec 31 2021 05:00 PM
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 choosing "select data" the Select Data Source window which appears states that "the data range is too complex to be displayed".
I would be most grateful if anyone could advise the next steps to take to display on my chart the additional data I have added to my table.
Jan 01 2022 12:53 AM
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)
Jan 01 2022 08:54 PM
Jan 01 2022 10:55 PM
Jan 02 2022 12:40 AM
I meant clicking on a series on the chart itself. That way, you don't have to use the Select Data Source dialog.
Jan 04 2022 08:32 PM
Jan 04 2022 08:39 PM
Thank you, Hans. Right-clicking on the chart itself, rather than the actual plot, seems to be the answer. Your advice is much appreciated.