Charts

teebird · Apr 11th, 2002, 05:04 AM

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

jrnyman · Apr 11th, 2002, 05:13 AM

It seems it would be easier to me if you organized it as:
q11998 Data Total
q21998 data total
q31998 data total
q41998 data total
q11999 data total
...

Then you should be able to record the macro charting the second column as a line and then the third as a bar graph on a separate axis. Let me know if you need code for converting the data or charting.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 05:04 AM	#1
teebird New Member Join Date: Apr 2002 Location: Aust Posts: 16	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

Apr 11th, 2002, 05:13 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	It seems it would be easier to me if you organized it as: q11998 Data Total q21998 data total q31998 data total q41998 data total q11999 data total ... Then you should be able to record the macro charting the second column as a line and then the third as a bar graph on a separate axis. Let me know if you need code for converting the data or charting.