Data Limit on Bar Chart?

  • Thread starter Thread starter SWFisherman
  • Start date Start date
S

SWFisherman

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.
 
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
 
Back
Top