Hi,

Here is some information on interactive charts.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Nikhil" wrote in message
...
I would like to have a chart displayed based on a store name that i select
from a dropdown list in a particular cell. How can i do that?

Thanks

Nikhil