LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jane
 
Posts: n/a
Default Line graph for cumulative number over time

I have a Problem Register with a single row entry for each problem raised
and, eventually, fixed. There is a Date Raised and a Date Fixed column.

I would like to display a line graph with cumulative no. of problems raised
over time and, ideally on the same graph, cumulative no. of problems fixed
over time. The Date Raised column I would expect to be in ascending order
but the Date Fixed column will be "random". As time progresses, one can see
the Fixed line closing in on the Raised line and eventually meeting.

eg
Prob Date Raised Date Fixed
1 2-JAN-2006 5-JAN-2006
2 2-JAN-2006 2-JAN-2006
3 3-JAN-2006 4-JAN-2006
4 4-JAN-2006 5-JAN-2006

I'm not getting very far on my own. Any suggestions?

Thanks,
Jane
 
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
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
Reference line in graph Sillie_J Charts and Charting in Excel 2 July 7th 05 10:52 PM
line graph ratio Charts and Charting in Excel 1 June 23rd 05 12:41 AM
Making a bar and a line graph together Santa Clause Excel Worksheet Functions 1 June 7th 05 07:59 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 02:42 AM.

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

About Us

"It's about Microsoft Excel"