Create a Bar in Bar Chart in Excel

[@zeynepela9762]

This was really brilliant. Just would like to share one learning from my side don't try to work it with 1 data point (for e.g. pizza actual/target) this stops you being able to format series.

[@Computergaga]

Thank you very much 😊

[@mohammedimani200]

Thank you, Alan. Simple but extremely effective visualization

[@Computergaga]

Thank you Mohammed.

[@vinay_tire]

Thanks for this tutorial... Helpful in compressing the contents and keeps better visibility ✌️✌️👏

[@Computergaga]

My pleasure 😊

[@emmachan9846]

This is a great video, simple clean and target oriented! Well done 👍🏻

[@Computergaga]

Thank you, Emma.

[@sambitguru8374]

Thank you so much. It was really helpful in creating my dashboard.

[@Computergaga]

Awesome! You're very welcome.

[@wayneedmondson1065]

Hi Alan.. cool solution. I have another approach which avoids the secondary axis scaling problem. Set up a standard bar chart with both series included. Set series overlap to 100% and then for the Target series, change the color to light green and change the border on that series to the same light green color. Then, increase the width of the border to something like 10 to 12 point and change the join type to Miter (for a flat edge). The result looks the same as your first example, but both series are on the same axis and so there is no scaling issue. The same procedure works for the comparison against multiple grades. You just need to set the border color, width and join type for each additional series, obviously using the same width and join type for each for consistency and the border color of each has to match the series color of each. So, that's my method. Give it a go and let me know what you think. Thanks for the videos.. always learn something new and fun at Computergaga. Thumbs up!

[@wayneedmondson1065]

@@MagnaAliqua Hi Sally.. thanks for your feedback! I hope it is of some use to you and others. Cheers!

[@Computergaga]

Excellent Wayne. Thank you for the technique and the lovely comments.

[@E.after.D.I.am.T.H]

This is very efficient and simple way . Thanks a lot

[@Sabirali00139]

Amazing tutorial I learn many new thing thanks for sharing gaga have a nice day.

[@Computergaga]

My pleasure Sabir. Thank you.

[@mohammedalsubaie3512]

Hi Alan, thank you so much your videos are really helpful and well presented.

[@Computergaga]

Thank you Mohammed. Your comments are appreciated.

[@harheeniuthayasooriyan4173]

is that possible if we apply this in data studio?

[@FaysalEasyExcel]

Thanks, its awesome and very helpful.

[@Computergaga]

You're welcome. Thank you.

[@Luciano_mp]

Thank you Alan!

[@Computergaga]

You're welcome. Thank you Luciano.

[@nickkaskarelis8995]

Excellent tutorial.

[@Computergaga]

Thank you Nick. Much appreciated.

[@maiggydicosta]

amazing

[@Computergaga]

Thank you.