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
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
Hi nandhamnk,
Is this what you want to do?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
No oldchippy.I like to show Plan & actual in the same bar with different colors.
hope u understand
Thanks
Originally Posted by oldchippy
Do you mean like this?
Yes oldchippy.You are correct.
Can you please explain hoe to do this?
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.
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
Try this one?
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
Yes, here you are
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks