Charts

teebird

New Member
Joined
Apr 8, 2002
Messages
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top