Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 45
Default Create a rolling 12 week graph

I am running Excel 97 SR-2. What I would like to do is to create a rolling 12
week graph that would always show only 12 weeks and would update the chart as
I added the new weekly data. I have the week number in column A, Productivity
% in column B and the goal in column C. I would like to graph both
productivity and the goal. Any help would be greatly appreciated.

Thanks,
Sheila
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 10,124
Default Create a rolling 12 week graph

Use a defined name such as this. modify to suit
Not an array formula.
=OFFSET($A$1,MATCH(99999999999,$A:$A,1)-7,0,7,1)
use this for colA and modify for colB and colC
then for source(s) use =filename.xls!definedname
don't use spaces.


--
Don Guillett
SalesAid Software

"Sheila" wrote in message
...
I am running Excel 97 SR-2. What I would like to do is to create a rolling
12
week graph that would always show only 12 weeks and would update the chart
as
I added the new weekly data. I have the week number in column A,
Productivity
% in column B and the goal in column C. I would like to graph both
productivity and the goal. Any help would be greatly appreciated.

Thanks,
Sheila



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Create a rolling 12 week graph

An alternative approach:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

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


"Don Guillett" wrote in message
...
Use a defined name such as this. modify to suit
Not an array formula.
=OFFSET($A$1,MATCH(99999999999,$A:$A,1)-7,0,7,1)
use this for colA and modify for colB and colC
then for source(s) use =filename.xls!definedname
don't use spaces.


--
Don Guillett
SalesAid Software

"Sheila" wrote in message
...
I am running Excel 97 SR-2. What I would like to do is to create a rolling
12
week graph that would always show only 12 weeks and would update the
chart as
I added the new weekly data. I have the week number in column A,
Productivity
% in column B and the goal in column C. I would like to graph both
productivity and the goal. Any help would be greatly appreciated.

Thanks,
Sheila





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
update week to week in excel. Rudy Excel Worksheet Functions 3 September 4th 06 03:20 PM
How to create a rolling 6 month average? anley Excel Discussion (Misc queries) 3 August 14th 06 12:41 PM
How do i create a funnel graph charliew Charts and Charting in Excel 1 April 3rd 06 11:47 AM
user defined function Brian Rogge Excel Worksheet Functions 5 May 23rd 05 06:21 PM
How do I create a Bell Curve Graph in Excel fratton Charts and Charting in Excel 2 March 17th 05 07:39 PM


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"