Thread: Create Charts based on data in Table

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

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
>
>