Hi Everyone
I have this data.
Q1 Q2 Q3 Q4 Total
1998 20 16 22 41 99
1999 41 35 55 52 183
2000 93 68 76 95 332
2001 51 86 57 139 333
2002 123 0 0 0 123
I would like my chart to display as a line graph the year at the bottom with a breakup of the quarters on top.
* *
* * * * * *
Q1 - Q2 - Q3 - Q4 Q1 - Q2 - Q3 - Q4
1998 1999
Then if possible behind this line on the same chart, another line showing the total for each year.
*
* *
1998 1999 2000
Hope I have explained myself enought. Many thanks for any help I get.
tee
I have this data.
Q1 Q2 Q3 Q4 Total
1998 20 16 22 41 99
1999 41 35 55 52 183
2000 93 68 76 95 332
2001 51 86 57 139 333
2002 123 0 0 0 123
I would like my chart to display as a line graph the year at the bottom with a breakup of the quarters on top.
* *
* * * * * *
Q1 - Q2 - Q3 - Q4 Q1 - Q2 - Q3 - Q4
1998 1999
Then if possible behind this line on the same chart, another line showing the total for each year.
*
* *
1998 1999 2000
Hope I have explained myself enought. Many thanks for any help I get.
tee