Selecting row data for chart - Not sure what I did right

[mcatan]

I wrote a pretty simple VBA program that sets rowhieght to zero for dat
rows that I want to hide in a bar chart. So if there are ten rows o
data and I only want to show certain bars in the chart, I set th
rowheight of the rows to zero and the chart redraws with only five bar
instead of ten. OK so far. I noticed that if I do data->sort of th
rows, the chart is messed up (all the spaces for the bars are installe
in the chart, but the bars appear collected on one side. If I add
dummy action such as copying dummy data from one cell to another, th
chart is ok again. I am wondering if this business of setting th
rowheight to zero to make bars disappear from the chart is a smart wa
to accomplish what I want. If I invest any more time in thi
application, I fear I may paint myself into a corner with it. An
suggestions about how to accomplish this without the rowheight trick

 

[mcatan]

Thanks much. I'll try to abuse and see if I run into trouble. Many
thanks.