|  | Charting and Dynamic Visibility | | |
| | | R Tanner |  |
|  Posted: Wed Jun 11, 2008 7:09 pm Post subject: Charting and Dynamic Visibility |  |
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 M | |
| | Posted: Wed Jun 11, 2008 8:22 pm Post subject: Re: Charting and Dynamic Visibility | |
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
LINK
On Wed, 11 Jun 2008 12:09:16 -0700 (PDT), R Tanner
<tanner.robin@gmail.com> wrote:
| Quote: | 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... |
|
| |
|
|
