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
|