Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change sheet names for charts on the fly
Hello, Everyone!
The following is a static formula that charts data from the Hypo! sheet. =SERIES(Hypo!$I$2,Hypo!Labels2,Hypo!Loads2,4) I need to replace Hypo with the name of the sheet the user selects. I tried: =SERIES(INDIRECT("'"& $O$2 &"'!$I$2"),INDIRECT("'"& $O$2 &"'!Labels2"),INDIRECT("'"& $O$2 &"'Loads2"),4) but Microsoft says "That function is not valid." Is this a syntax issue, or can you not use INDIRECT with SERIES? Any help would be appreciated. Have a great day. Arlen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change sheet names for charts on the fly
Try adding a worksheet named chart data, reference the Chart to the data
table there, and then use INDIRECT to modify the referenced chart data on the fly -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Arlen" wrote: Hello, Everyone! The following is a static formula that charts data from the Hypo! sheet. =SERIES(Hypo!$I$2,Hypo!Labels2,Hypo!Loads2,4) I need to replace Hypo with the name of the sheet the user selects. I tried: =SERIES(INDIRECT("'"& $O$2 &"'!$I$2"),INDIRECT("'"& $O$2 &"'!Labels2"),INDIRECT("'"& $O$2 &"'Loads2"),4) but Microsoft says "That function is not valid." Is this a syntax issue, or can you not use INDIRECT with SERIES? Any help would be appreciated. Have a great day. Arlen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change sheet names for charts on the fly
This might help you if i have got your problem right.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Thanks Suleman Peerzade "Arlen" wrote: Hello, Everyone! The following is a static formula that charts data from the Hypo! sheet. =SERIES(Hypo!$I$2,Hypo!Labels2,Hypo!Loads2,4) I need to replace Hypo with the name of the sheet the user selects. I tried: =SERIES(INDIRECT("'"& $O$2 &"'!$I$2"),INDIRECT("'"& $O$2 &"'!Labels2"),INDIRECT("'"& $O$2 &"'Loads2"),4) but Microsoft says "That function is not valid." Is this a syntax issue, or can you not use INDIRECT with SERIES? Any help would be appreciated. Have a great day. Arlen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change sheet names via formula | Excel Discussion (Misc queries) | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Named sheet to change Cells names | New Users to Excel | |||
how to change font size of datalabels of two charts in a sheet | Charts and Charting in Excel | |||
Range Names with Charts | Charts and Charting in Excel |