software

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

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: www.excelforum.com/member.php...foamp;userid=5498
View this thread: www.excelforum.com/showthread...hreadid=493775Hi,

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

Cheers
Andy

gordon_conroy wrote:
gt; Hi All
gt; Need to combine 2 charts
gt; I have the Exp below in a stacked column chart and I can combine it
gt; with Revenue as a line chart to view both of them together.My problem
gt; is I want to see the Revenue as a column right beside the stacked
gt; column
gt;
gt; Cheers,
gt; Gordon
gt;
gt; yr1 yr2 yr3
gt; Exp1 3 4 5
gt; Exp2 1 2 3
gt; Exp3 6 7 8
gt;
gt; Revenue 5 20 10
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info