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.

I find it hard to follow what it is that you are actually saying. Are you
trying to create a chart of a number of values from only one dropdown or
from a number of dropdown boxes?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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.

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.