| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using INDIRECT in the SERIES function...possible?
Here is a static formula for the Series "Loads"
=SERIES(Hypo!$I$2,Hypo!Labels2,Collect.xls!Loads2, 4) This only graphs what is on the Hypo page. (By the way, why is the last Hypo subbed with Collect.xls?) I need instead to switch between 3 pages. I tried the following: =SERIES(INDIRECT("'"& $O$2 &"'!$I$2"),INDIRECT("'"& $O$2 &"'!Labels2"),INDIRECT("'"& $O$2 &"'Loads2"),4) and Excel simply says That is not a valid function. The end. Why doesn't this work? Each individual piece returns the right information. I appreciate any help you got. Have a great day! Arlen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect function | Excel Discussion (Misc queries) | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| how do I define a chart series with an indirect reference | Charts and Charting in Excel | |||
| I have a problem fillling series with indirect function | Excel Worksheet Functions | |||
| CHARTING W/INDIRECT SERIES | Charts and Charting in Excel | |||
Threaded Mode
