D
Discourage
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 =)
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 =)