Need help auto-updating chart data sources.

[Julz]

Am trying to automate a spreadsheet that has been copied and pasted by
hand for way too long. Here's what I need to do.

Spreadsheet DOR auto-updates spreadsheet AGING. Now I'm needing to have
the corresponding charts in AGING update with the newly added data..
Let's say that column A contains dates that that are used to populate
the Z axis on my chart.. The Z axis of my chart always displays 6 dates
worth of data.. What I'd like to have happen is when AGING is opened
and auto-updated, the corresponding charts also update. Dropping the
1st position Z axis label (date) and adding the new one at the end.

Not sure if this can be done, or if I'm even making sense. Please
advise!

Thanx,
~Julz

 

[Frank Kabel]

Hi
have a look at
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[Julz]

Frank,

Thanx as always for your assistance. I checked out both sources and was
not able to apply the logic to what I'm doing. Meaning... I must be doing
something wrong. What other options are available?

Thanx,
~Julz

 

[Jon Peltier]

Julz -

Could you describe what you've tried, and how it fell short?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/Excel/Charts/
_______