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/
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