Hello,
I am having some difficulties setting up a large work book with auto-updating graphs.
I used "Define Name" to set up named ranges for the graphs as such:
Month: =OFFSET('4A'!$A$2,0,0,COUNTA('4A'!$A:$A)-1)
Count: =OFFSET('4A'!$B$2,0,0,COUNTA('4A'!$A:$A)-1)
This works fine to set up a graph for worksheet "4A", but the file I'm working with has 4A,4B,4C,5A,5B,... etc., etc. Is there a way I can make the names "Month" and "Count" always refer to the active sheet, and not have to define names for each sheet?
See the attachment for a simplified version of what I'm working with.
I greatly appreciate any help you can offer!
Bookmarks