Formatting a chart to update automatically

H

HelptheAdmin

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a chart in Powerpoint to update automatically 0
Excel 2007 graphs/charts automatically populate with new data 1
Earned value (BCWP) showing as zero in chart 0
Pivot Charts from Excel not to update automatically 0
Excel 2007 charts: want to avoid zero values 1
Embedding Excel charts in PowerPoint 1
Automatic (SQL) updated charts in PP 2007 0
Problem with MS Word paragraph and character styles: format getting messed up 2

Top