Display charts using drop down menu

[sbharti18]

All,

I have a large amount of data for 13 units, out of which i have made around 39 charts (3 for each), now the problem i face is that I do not want to clutter my page with all the charts put together. I want to give users a drop down from which a person can select a parameter (i.e. unit name) and get the relevant 3 charts displayed....

can someone bail me out here......

[Palmetto]

See this for a start: Interactive Charting by Combo Box or Checkbox

Also:
Dynamic Charting Formulas in Excel
Create a Dynamic Chart in Excel in 2 Minutes