Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding extra data to a chart
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding an extra row after every existing row | Excel Discussion (Misc queries) | |||
Adding and Removing Extra Pages | Excel Discussion (Misc queries) | |||
Extra data plotted on chart | Charts and Charting in Excel | |||
tab delimited adding extra tabs | Excel Discussion (Misc queries) | |||
adding extra marker styles | Charts and Charting in Excel |