Simple Excel Trick to Conditionally Format Your Bar Charts
23 July 2020 Excel Charts
If you want to help your audience to make sense of your Excel chart quickly, consider color coding it. In this video I'll show you how you can apply Conditional Formatting to show different colors for positive and negative deviations. This way you can quickly create an Excel bar chart with conditional formatting based on change % or based on any logic you choose.
Comparison charts and bar graphs in Excel can be quite intimidating and force the reader to spend considerable time to make sense of them. Color can help to immediately grasp important patterns in the chart like good and bad performance. Research also shows that information that's color coded is easier understood and better retained in memory. For example if you use a column or bar chart to show deviations you can have a different color for negative values to positive values. You might choose to show the bars for negative values in red and positives values in green or any other color of your choice.
I'll show you a technique how you can apply such conditional formatting to any type of chart in Excel. As a bonus tip I'll cover how to emphasize a particular part of a chart like the maximum value by defining a logic.
⯆ DOWNLOAD the workbook at the bottom of the blog post here: https://www.xelplus.com/excel-conditional-bar-charts
Complete Excel Dashboard Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyz_4TwSfxzN_gsRtg3ODzyx
Excel data visualization & advanced chart tricks: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps
00:00 Conditional formatting of charts
00:48 Setting up first bar chart
03:17 Setting up the deviation chart
05:31 Negative red, positive green
06:31 Conditional formatting of maximum value or other logic
09:32 Finalizing the charts (grouping charts together)
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
LIVE
Matt Kohrs
10 hours agoGameStop Is Squeezing, China on Tilt & The Week Ahead || The MK Show
2,292 watching -
LIVE
Rethinking the Dollar
42 minutes agoNext Banking Event Will Be Off The Charts | Monday Morning Check-In: A Quick Glance IN The News
885 watching -
1:37:00
The Podcast of the Lotus Eaters
6 hours agoThe Podcast of the Lotus Eaters #913
23.9K13 -
6:37
Chris Jericho
21 hours agoThe Unsolved Mystery & Murder of Rachel Morin
15.6K1 -
20:17
PARAGRAPHIC
1 day agoLeading the Way in Costa Rica's Culinary Scene | PARAGRAPHIC
19.1K1 -
9:00
Bearing
1 day agoMeet the Woman Trying Censor the WORLD! Australia's E-Safety Commissioner Mad with Power
13.9K24 -
9:10
DepressedGinger
14 hours ago7 MLB teams that are STRUGGLING with Attendance in 2024
19K9 -
3:32:48
Due Dissidence
20 hours agoMorning Joe and Hillary SMEAR Students, DNC Fears CONVENTION CHAOS, Carville MELTS DOWN Again
44.2K151 -
1:22:39
The Late Kick with Josh Pate
17 hours agoLate Kick Live Ep 512: Portal Winners & Losers | SEC Truths + Questions | Portal Winners & Losers
59.3K6 -
1:50:27
vivafrei
23 hours agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
189K288