See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

particularly examples 3,5,6.

--
Regards,

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

In article <MAttenborough.1v1pmf_1126191929.8899@excelforum-
nospam.com,
says...

I would like to create a series of charts that are dependant on data
stored in a table. Specifically I would like to pull data from the
table based on Dates in a table for example. The Table contains Dates
in Column A, then a variety of other informaion going across the
columns. I would like to extract and chart data based on a date range
say Jan 1st - Jan 31st. I would like to do this a formula based in
named ranges like "PerOneStartDate" to "PerOneEndDate". This would
give flexibility in changing the reange without having to go to the
table and select data.

Thank you


--
MAttenborough
------------------------------------------------------------------------
MAttenborough's Profile: http://www.excelforum.com/member.php...o&userid=27072
View this thread: http://www.excelforum.com/showthread...hreadid=465918