Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I limit labels in chart legend to only a portion of data? | Charts and Charting in Excel | |||
Best way to limit data for chart? | Charts and Charting in Excel | |||
Can I use the autofilter feature to limit data for a pivot chart? | Charts and Charting in Excel | |||
Is there a limit to the number of points in a chart source data | Charts and Charting in Excel | |||
How do I add a limit line to a chart, so I can see where a data p. | Charts and Charting in Excel |