Create a rolling 12 week graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheila - 11 Oct 2006 16:37 GMT

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 to this Message

Don Guillett - 11 Oct 2006 19:23 GMT

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.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I am running Excel 97 SR-2. What I would like to do is to create a rolling
>12
[quoted text clipped - 7 lines]
> Thanks,
> Sheila

Reply to this Message

Jon Peltier - 13 Oct 2006 03:49 GMT

An alternative approach:

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

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

> Use a defined name such as this. modify to suit
> Not an array formula.
[quoted text clipped - 14 lines]
>> Thanks,
>> Sheila

Reply to this Message