Combining stack column chart and non stacked
 

Hi All
Need to combine 2 charts
I have the Exp below in a stacked column chart and I can combine it
with Revenue as a line chart to view both of them together.My problem
is I want to see the Revenue as a column right beside the stacked
column :confused:

Cheers,
Gordon

yr1 yr2 yr3
Exp1 3 4 5
Exp2 1 2 3
Exp3 6 7 8

Revenue 5 20 10


--
gordon_conroy
------------------------------------------------------------------------
gordon_conroy's Profile: http://www.excelforum.com/member.php...fo&userid=5498
View this thread: http://www.excelforum.com/showthread...hreadid=493775

Combining stack column chart and non stacked
 

Hi,

Stacked cluster charts can be created by careful layout of your data.
Jon Peltier has details
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

gordon_conroy wrote:
Hi All
Need to combine 2 charts
I have the Exp below in a stacked column chart and I can combine it
with Revenue as a line chart to view both of them together.My problem
is I want to see the Revenue as a column right beside the stacked
column :confused:

Cheers,
Gordon

yr1 yr2 yr3
Exp1 3 4 5
Exp2 1 2 3
Exp3 6 7 8

Revenue 5 20 10



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info