How do I create an auto updating excel chart?

  • Thread starter Thread starter dave01
  • Start date Start date
D

dave01

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?
 
Back
Top