Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update week to week in excel. | Excel Worksheet Functions | |||
How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
How do i create a funnel graph | Charts and Charting in Excel | |||
user defined function | Excel Worksheet Functions | |||
How do I create a Bell Curve Graph in Excel | Charts and Charting in Excel |