Thread: Creating two stacks in one bar

Hi Brains,

I need to show Plan for 6 years and plan vs actual (sheet1-c8) in 2007 year in the same bar.
is it possible?

Attached excel for your reference.

Thanks in advance

No oldchippy.I like to show Plan & actual in the same bar with different colors.
hope u understand

Thanks

Originally Posted by oldchippy

Hi nandhamnk,

Is this what you want to do?

Yes oldchippy.You are correct.

Can you please explain hoe to do this?

Originally Posted by oldchippy

Do you mean like this?

Iam sorry oldchippy.Misunderstood the chart.

No,chart should not be like this.

Actual should be the part of the Plan.

i.e first 22 is actual (different color ) & remaining is Plan

Purpose to show what is actual compared to plan till date

Thanks

Originally Posted by oldchippy

OK,

Select data A26:C33, click Chart Wizard icon, select the second icon in the Column Chart type > Finish. you can alsoo add title, legend etc.

Thanks.got it!

So i need to make overlap as 100 in Actual bar,that fits into.

Is it possible to make this in 3D chart too

Thanks for the solution

Originally Posted by oldchippy

Try this one?