Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you chart data from multiple sheets within a workbook?
How do you chart data from multiple sheets within a workbook? I'd like to create a line graph illustrating the increase in one cell's values across the many sheets in one workbook.
Thanks, J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you chart data from multiple sheets within a workbook?
I don't believe the latter can be done. One can put line1 and line2
from different sheets on one chart. However, all points on line1 must come from one sheet only; ditto for line2. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you chart data from multiple sheets within a workbook?
It can be done. I've used macros in the past to gather data which is not sequentially located, then charted the result. Do a Google Search for ..SeriesCollection(1).Values = Array( That should get you started. Basically, you create array variables in your macro then stuff them into the number series for your charts. It's a bit of a pig to get your head around, but it does work. Greg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you chart data from multiple sheets within a workbook?
It can be done. *I've used macros in the past to gather data which is not sequentially located, then charted the result. Not sequentially located on *one* sheet, fine. Not sequentially located on *more than one* sheet is a different matter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to chart data from multiple sheets in Workbook | Excel Programming | |||
Change multiple Chart Titles in different sheets in the same Workbook | Excel Worksheet Functions | |||
copy chart between multiple sheets in workbook | Charts and Charting in Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
chart data from same cell on multiple sheets | Charts and Charting in Excel |