Hi
I have an excel dashboard with three worksheets. The first worksheet
is the dashboard that displays the information. In the worksheet, it
has a control bar with a slider to select the year. And when the year
is selected, ex. 2006, the spend for each category for that year would
show up. The spend data is coming from another worksheet and it is
basically a table in cells A:2 to F:10. In Col A:3;A:10, it is the
categorie names, in Col B. has 2002 and dollar spend information, Col
C has 2003 spend, Col D has 2004 spend and so on.

My question is that can I create a macro to display a pie chart on the
first worksheet and when that certain year is selected, the
corresponding column of data and pie chart would be shown.

Thank you for your help.

hi dd

here's a link about dynamic charts from jon
http://peltiertech.com/Excel/Charts/Dynamics.html

maybe that gives you some background for solving your problem

Carlo

On Jan 10, 9:36*am, dd <dd2qu...@gmail.com> wrote:
> Hi
> I have an excel dashboard with three worksheets. The first worksheet
> is the dashboard that displays the information. In the worksheet, it
> has a control bar with a slider to select the year. And when the year
> is selected, ex. 2006, the spend for each category for that year would
> show up. The spend data is coming from another worksheet and it is
> basically a table in cells A:2 to F:10. In Col A:3;A:10, it is the
> categorie names, in Col B. has 2002 and dollar spend information, Col
> C has 2003 spend, Col D has 2004 spend and so on.
>
> My question is that can I create a macro to display a pie chart on the
> first worksheet and when that certain year is selected, the
> corresponding column of data and pie chart would be shown.
>
> Thank you for your help.