Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Discourage
 
Posts: n/a
Default Help with 2 values

Hi,
I dont really know how to explain this so I will give an example 1st:

Row1 Row2 row3
3 20 16/04/2005
2 27 16/02/2005
4 10 10/06/2004
4 17 11/05/2004
3 45 11/03/2003
1 6 11/05/2004
2 87 30/03/2005
1 12 25/04/2005
2 28 20/02/2005
3 20 10/04/2005
1 19 01/01/2004

Row one is priority ranging from 1 to 4, row2 is in days, row3 is the
date which the item was created.
I need to produce a graph with the x axis being week ending date, the y
axis being amount of days and the values on the graph to be the priority.

The graphs will be split into 3, less than 27 days, less than a year but
more than 27 days and the 3rd will be more than a year old.

I need to find a way to distinguish something that is, for example, 27
days old, and priority 3, from something that is 27 days old and
priority 2 etc to form these graphs.

I have looked into many functions on how to do this, and can compare 2
etc and generate the graph, but comparing 3 items is proving difficult.

Has anyone got a good solution to this? I hope I have explaned this well
enough :/

Thanks in advance =)
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
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
How do I summarize totals for a list of values in Excel? KelleyS Excel Worksheet Functions 2 April 13th 05 09:56 PM
How To Use Cells Without Values in a Formula Roger H. Excel Worksheet Functions 2 April 6th 05 01:01 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
Need to sum values of columns 1 - 13 and 4 - 15 ExcelHelp Excel Worksheet Functions 1 October 27th 04 07:03 PM


All times are GMT +1. The time now is 06:50 PM.

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"