![]() |
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 =) |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com