Hide The Range But Show Without Hiding The Chart Graph Series

[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

[Excel Fox]

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/change-data-series-in-chart-using-drop-down-list-1197/

[rich_cirillo]

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