Hi,

You need to set up dynamic named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

And here is some information on charting from selected data
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

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

I want to create a chart with dynamic data from a drop down. Like if i
select option 1 in the data validation drop down the chart should populate
with data from sheet 1. and if i select 2 then it should populate with
sheet
2 data.

Please suggest a way to do the same

thanks
sudheera