Formatting a chart to update automatically

[Guest]

I want to set up a 12 month rolling chart that will automatically remove the
oldest month, insert the new month, and apply blank cells for input of the
new data. I am told it is possible, but can find noone that know how. The
charts I am working with are standard PowerPoint line graphs. I assume that
the programming/formatting I am looking to is related to the date in my
computer. Not really sure how that works. I am able to program macros in
Excel but have been unsuccessful with attempts to program macros in
PowerPoint. Any knowledge is greatly appreciated.

 

[Glen Millar]

Hi,

While this might be possible with vba, I'd suggest you ask this in the Excel
newsgroup first. Those peoples *eat* charts for breakfast. Then, when you
figure out how, you could paste the resultant chart back into PowerPoint. I
know that the Graph feature in PowerPoint can't so this without vba help.

--
Regards,

Glen Millar
Microsoft PPT MVP
www.powerpointworkbench.com

Australia