From: JR Hester on
John,
Thanks for this post, between this forum and your Chart the last 12 months
on your website, i was able to solve a problem for one of my coworkers.

"Jon Peltier" wrote:

> Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as
> the data source.
>
> Option B: Use dynamic ranges as the source data:
>
> http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
> http://peltiertech.com/Excel/Charts/Dynamics.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "dave01" <dave01(a)discussions.microsoft.com> wrote in message
> news:F340A12B-1A1F-4A50-904F-261D386EB5B6(a)microsoft.com...
> >I have moved over to excel 2007 and cannot work out how to create a chart
> > that updates automatically. Can anyone help ?
>
>
>