How do I create an auto updating excel chart?
 

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

How do I create an auto updating excel chart?
 

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 ?

How do I create an auto updating excel chart?
 

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 ?

How do I create an auto updating excel chart?
 

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 ?