View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brian Murphy[_2_] Brian Murphy[_2_] is offline
external usenet poster
 
Posts: 22
Default how to hide a chart series or make it invisible

I may have answered my own question.

How about to hide a series redefine the Values property to point to some
empty worksheet cells. Then to unhide restore the original Values property
which I suppose could be a Range, Name or Array. Maybe save the
Series.Formula property and use that to restore the Values property.

Brian




"Brian Murphy" wrote in message
...
I want to make some chart series invisible (hide them), and then later
restore them.

Is there an easy way to do this without messing with a whole lot of chart
series formatting properties?

Thanks,

Brian Murphy
Austin, Texas