Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Data Limit on Bar Chart?

I am trying to display a Clustered Column chart that is pulling data from
multiple worksheets. I have 12 worksheets containing data & the chart is on
its own seperate worksheet. Each worksheet has 4 or 5 rows of data in 3
columns, 2 columns contain actual data & the other contains text for date
headings.

When using the chart wizard I can graphically select the data w/ my mouse &
it lets me get 2 worksheets worth of data then I cannot input anymore. When
I try to put in more it resets the data window to just one entry, instead of
that one plus the other 9 I just selected.

I find it hard to beleive that they would limit a chart to so few data
entries. In total there are less than 200 cells that data needs to be pulled
from. Any clue as to how I can go about this the right way w/o having to
pull all the data into 1 worksheet?

Let me know if I can help explain this any better.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Data Limit on Bar Chart?

Are you by chance selecting one cell at a time? The limit in this case is
how long the text string is that contains the references to each separate
cell. The remedy is to designate a range on one sheet that links to all of
the cells elsewhere in the workbook, so that you can plot from one
contiguous range. This is better for the chart, and easier for the human
operator.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"SWFisherman" wrote in message
...
I am trying to display a Clustered Column chart that is pulling data from
multiple worksheets. I have 12 worksheets containing data & the chart is
on
its own seperate worksheet. Each worksheet has 4 or 5 rows of data in 3
columns, 2 columns contain actual data & the other contains text for date
headings.

When using the chart wizard I can graphically select the data w/ my mouse
&
it lets me get 2 worksheets worth of data then I cannot input anymore.
When
I try to put in more it resets the data window to just one entry, instead
of
that one plus the other 9 I just selected.

I find it hard to beleive that they would limit a chart to so few data
entries. In total there are less than 200 cells that data needs to be
pulled
from. Any clue as to how I can go about this the right way w/o having to
pull all the data into 1 worksheet?

Let me know if I can help explain this any better.



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
How do I limit labels in chart legend to only a portion of data? Chart legend label limitation Charts and Charting in Excel 1 March 18th 08 04:17 PM
Best way to limit data for chart? Cheese_whiz Charts and Charting in Excel 1 January 15th 08 10:12 PM
Can I use the autofilter feature to limit data for a pivot chart? Randy Charts and Charting in Excel 0 December 19th 05 05:26 PM
Is there a limit to the number of points in a chart source data jantoni Charts and Charting in Excel 1 December 9th 05 03:43 PM
How do I add a limit line to a chart, so I can see where a data p. Patrick question on chart reference Charts and Charting in Excel 1 March 11th 05 12:56 AM


All times are GMT +1. The time now is 07:05 PM.

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

About Us

"It's about Microsoft Excel"