Pivot Chart based on dropdown menu

[javedmati]

Hi,

I have an excel which has 2 worksheet named as DATA & CHART.

In the worksheet named as "DATA", I have entered expenses of sales employees from January to December.

Cell A1 of worksheet "CHART" has a dropdown list and user can select any month of the year. Based on what the user selects in cell A1, I wanted to generate the Pivot Chart. For e.g. if user selects APRIL, then I want to generate the CHART only for April month.

Can someone please help me...

Regards,
Javed

 

[Derek Brown]

Whenever I need a special chart or need some ideas, there is only one place for me to go:
http://peltiertech.com/Excel/Charts/ChartIndex.html

You may find the following useful:
http://peltiertech.com/Excel/Charts/ChartByControl.html