ExcelBanter - Adding extra data to a chart

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Tracey" wrote in message
...
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?