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