Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 78
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding an extra row after every existing row Josh W Excel Discussion (Misc queries) 10 April 14th 08 09:56 PM
Adding and Removing Extra Pages Marcus Feldmore Excel Discussion (Misc queries) 1 January 23rd 08 06:42 PM
Extra data plotted on chart Dan Charts and Charting in Excel 2 November 29th 07 02:34 PM
tab delimited adding extra tabs maryj Excel Discussion (Misc queries) 0 April 18th 07 07:50 PM
adding extra marker styles Grizzabella Charts and Charting in Excel 4 September 15th 05 04:31 AM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"