Adding extra data to a chart

[Tracey]

I am having Trouble with a scatter chart i can only add up to ~11 Y values
before it wont let me create the chart if i add anymore why is this??

Can i stop it from occuring?

 

[Jon Peltier]

You really ought to use a contiguous range to hold your data. If you need to
gather data from separate cells, gather them using formulas in a single
column, then plot this column.

The problem is that the series formula has a limit on its length. Every cell
you add contains a number of characters, "Sheet1!$A$1" is eleven characters,
plus a comma, plus brackets surrounding the whole string of them. If your
sheet name is much longer, it's easy to see how you run out of characters
after ten or twelve points.

- Jon