Charting and Dynamic Visibility

[R Tanner]

Is there a dynamic visibility option available through excel? So for
example, I am trying to create a dynamic analysis dashboard using drop
down menus, charts, and vlookup tables. I want checkboxes to make
charts and drop down menus disappear according to their value. At
least, that is the way I used to do it with Xcelsius. I don't have
that program anymore though, so I am trying to do it with Excel...Any
thoughts?

Thanks...

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

Excel doesn't have built-in features to do what you want. To some
extent, you get those capabilities with a PivotChart. Alternatively,
you would have to roll your own. For building blocks see
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html