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