Stacked Bar Chart Help

[nitrobass24]

Trying to create a stacked bar chart with multiple series and am not sure how to lay out my data. Keep getting Series 1 that contains data from all three.

Right now I have my data like follows

[TABLE="width: 491"]
<tbody>[TR]
[TD]Control[/TD]
[TD]No Variance[/TD]
[TD]High Impact[/TD]
[TD]Low Impact[/TD]
[TD]GSA Additonal ATP[/TD]
[/TR]
[TR]
[TD]PS-1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]PS-2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]PS-3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]PS-4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

I would like a bar chart with 3 columns: No Variance, Impact, GSA. With the Impact Column being stacked with high/low.

 

[Andrew Poulsom]

Plot your data as a Clustered Column Chart, move the Impact Series to the Secondary y Axis and change their chart type to Stacked. Then adjust Overlap and Gap Width to get the look you want.

 

[nitrobass24]

Plot your data as a Clustered Column Chart, move the Impact Series to the Secondary y Axis and change their chart type to Stacked.

Sorry I don't understand what this means.

 

[Andrew Poulsom]

Right click the Series and choose Format Data Series. On the Axis tab check Secondary axis and click OK. Right click again and choose Chart Type, select Stacked Column and click OK.