Create Pie Chart that changes from one data table with differentyears

D

dd

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Dates In Excel 5
Creating Network Diagram using a Chart SW integration 0
Creating a Chart on form from selected data in query. 0
Pie Chart and Table Query 2
Sumif using partial string 7
create chart with column axis 10

Top