Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |