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

Thank yo

--
MAttenboroug
-----------------------------------------------------------------------
MAttenborough's Profile: http://www.excelforum.com/member.php...fo&userid=2707
View this thread: http://www.excelforum.com/showthread.php?threadid=46591

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>, MAttenborough.1v1pmf_1126191929.8899...rum-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
>
>