G
Gromit
Hi,
I have 12 chart series in a chart (Excel 2000), any or all of which ca
be hidden by the user using a Forms control (the cell values becom
=NA() when the form control is FALSE). All works nicely except th
legend shows all 12 series all the time. What's the best way of havin
the legend reveal only the visible series? Is there a way of doing i
without VBA?
One thought I had was to make the appropriate chart series name value
resolve to "". This would hide the series label, but not the line,
guess.
Thanks for any thoughts
I have 12 chart series in a chart (Excel 2000), any or all of which ca
be hidden by the user using a Forms control (the cell values becom
=NA() when the form control is FALSE). All works nicely except th
legend shows all 12 series all the time. What's the best way of havin
the legend reveal only the visible series? Is there a way of doing i
without VBA?
One thought I had was to make the appropriate chart series name value
resolve to "". This would hide the series label, but not the line,
guess.
Thanks for any thoughts