In article ,
says...
Thanks, but I don't see what i'm looking for on that page (may be dynamic is
not the right word). What I need is to let the user select which location to
see its chart. Once the user select the desired location the chart for the
location will be populated on the chart window (only the chart for that
location). I'm trying to save memory and time by not creating 40 different
sheets with 40 different charts on the same file. May be a VBA would help.
Like having a procedure/function that once the location get selected, the
code will look for corresponding location's data table and plot the line
chart. Any help is greatly appreciated.

Thanks.

An example of what you want would be to combine example #4 with example #6
in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions