View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sheila Sheila is offline
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