Hi,

Have a look at Jon's example of changing chart content with controls.
http://peltiertech.com/excel/charts/ChartByControl.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jithu" wrote in message
...
Hi all,

can anyone help me to create charts from data in a drop down box?

the chart is common. when the user select a particular item, the
corresponding data should be displayed in the chart.(x and y axis same for
all, only data value changes)

Thanks in advance for your advice.


Jithu.