Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use a different spreadsheet as source data
Presently, I have a radar comparing YTD actual 2009 vs YTD budget 2009 but I
want to provideto user the capability of seeing maybe actual 2008 vs budget 2008. Meaning that I am looking for a way to change the automatically not the X or Y (it will remain the same) but change the sheet used as the source data for the graph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.xlt does not contain new data from source spreadsheet. | Excel Discussion (Misc queries) | |||
Drop Down Menu ~ Source from Different Spreadsheet | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Use spreadsheet as data source | Excel Discussion (Misc queries) | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |