When I hide rows 55 to 66 it also hides the graph.How can I hide the rows 55 to 66 but keep the graph always visible
Cheers
Rich Cirillo
When I hide rows 55 to 66 it also hides the graph.How can I hide the rows 55 to 66 but keep the graph always visible
Cheers
Rich Cirillo
You'll need to use a dummy table for this, or write a more elaborate macro which codes the series based on the visible range of cells.
This http://www.excelfox.com/forum/f2/cha...own-list-1197/
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
I had a look at the file in post #2...it also removes the graph when the rows are hidden...what sort of macro would I require...would prefer to use the NA table and just hide the rows but do you believe this is not possible
Cheers,,,,Rich
Posting Permissions
Reply With Quote
Bookmarks