Thread: 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

Cheers,
Gordon

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

Revenue 5 20 10

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
>
> 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