Charts form drop down

[Guest]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Andy Pope]

Hi,

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

Cheers
Andy