I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ?

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/...umnChart1.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" wrote in message
...
I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ?

I've been trying to understand your directions on your website for charting
the last 12 months dynamically and am having trouble translating it to my own
needs. I understand pretty much what you are doing, but my situation is a
little different.

I have data comparing the same week (Mon.-Sat.) from 2007 to the one in
2008. Each week I have data (total call volume) for 6 lines of business. I
want to create a cluster column bar chart with lines of business on the
x-axis and call volume on the y-axis that shows both weeks and updates with
new data for the previous week and the corresponding week from a year ago.
Is this possible?

"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/...umnChart1.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" wrote in message
...
I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ?

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/...umnChart1.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" wrote in message
...
I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ?