How to make bar charts more interesting in excel

[@ianl1052]

Thanks for your deep dive into Chart formatting. It looks great. Here's a tip I picked up purely by accident. When changing data by the same amount, select the range, enter the new data in the Formula bar and press Ctrl+Enter. This fills the entire selected range without the need to copy and paste. On a whim, I went back and selected both 5% ranges and repeated what I just described. Yay! It also works on multiple ranges. It works with formulas too as long as it's the same formula.

[@nsanch0181]

Beautiful Bar chart. Thank you Karina for the great video.

[@IsaiahChapter53JESUS]

Hi Karina, that's really excellent. Helpfully presented. Keep abounding.

[@ScientificJaunt]

Very useful. Keep educating.

[@sajjadali8655]

Great tutorial. Looks pleasing 🙂👍

[@Akhil-il4wb]

Excellent chart! Could you please make a video for the same chart but with macro so that I can use macro for the changing categories and data?

[@AlexandreMitchell1]

thanks. Great explanations. How would you do something similar but with stacked data. Ex: how would you stack 5 columns of percentages (that all arrive to 100%) on that sausage bar. I'm trying to produce rounded edges on either side for each of the 5 percentages on each bar.

[@kingjorges]

Perfect

[@IOSALive]

Karina Adcock, cool content

[@thamimunansari2958]

Amazing. Thank you...

[@faridsharafi1990]

Thanks 🙏 🙏 🙏

[@sunnindawg]

Nice!

[@faridsharafi1990]

PLEASE TEACH DASHBOARD TOO

[@daget34]

This stops working when there are 0% categories in the data. FYI. If you want you can use the formula =MAX(A1 - B1, 0) in the cell so that the difference if zero wont result in a negative value.