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.