Hi,

For information on dynamic charts and controlling which series are
displayed have a look at Jon's page.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

sahafi wrote:
Hi All,

I'm trying to set up line charts for more than 40 different production
locations. But I would like to give the user the option of selecting one or
two (at most) locations then have Excel display the corresponding chart/s
instead of creating 40+ charts. Each location will have its own data table
(pounds/dollars). How do I go about doing this task?

Thanks.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info