Thread: Automatic update of graph for 13 weeks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Automatic update of graph for 13 weeks
Hi,

Have a look at the technique described by Jon Peltier, which you should be
able to adapt for your data set are required period numbers.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mursin" <u35883@uwe wrote in message news:7540e5778c97a@uwe...
Hi,

I have a worksheet with 52 work weeks on it. Each week I enter in new data
and I want my graph to update for the latest 13weeks....

Does anyone know how to do this??


Reply With QuoteReply With Quote
 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.
Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.