How to stack items on a clustered column chart

PeterCol · Mar 29th, 2004, 11:15 AM

I want to format a chart showing months on the X axis and quantity on the y axis. I want to use a clustered column so that I can compare the yearly values for each month. i.e. 2001, 2002, 2003 for Jan, then Feb etc.

So far is simple.

The additional item I would like to add is have each of the yearly columns stacked so that I can compare 2 items within that yr and month. I can't find a standard chart that will do that.

Can anyone help?

PaddyD · Mar 30th, 2004, 06:24 AM

perhaps this will help:

http://www.mrexcel.com/board2/viewtopic.php?t=82963

PeterCol · Mar 30th, 2004, 02:08 PM

Yes, that was excellent. Thanks

Mar 29th, 2004, 11:15 AM	#1
PeterCol Join Date: Jun 2003 Posts: 18	How to stack items on a clustered column chart I want to format a chart showing months on the X axis and quantity on the y axis. I want to use a clustered column so that I can compare the yearly values for each month. i.e. 2001, 2002, 2003 for Jan, then Feb etc. So far is simple. The additional item I would like to add is have each of the yearly columns stacked so that I can compare 2 items within that yr and month. I can't find a standard chart that will do that. Can anyone help?

Mar 30th, 2004, 02:08 PM	#3
PeterCol Join Date: Jun 2003 Posts: 18	Re: How to stack items on a clustered column chart Yes, that was excellent. Thanks

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

Mar 30th, 2004, 06:24 AM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 12,561	perhaps this will help: http://www.mrexcel.com/board2/viewtopic.php?t=82963