Simple Excel Trick to Conditionally Format Your Bar Charts
206 هزار بار بازدید -
4 سال پیش
-
Join 400,000+ professionals in our
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
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.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/conditional...
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.
Complete Excel Dashboard Playlist: Excel Dashboards & Reports
Excel data visualization & advanced chart tricks: Excel Charts
★ My Online Excel Courses ► https://www.xelplus.com/courses/
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)
➡️ Join this channel to get access to perks: @leilagharani
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
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!
#excel
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.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/conditional...
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.
Complete Excel Dashboard Playlist: Excel Dashboards & Reports
Excel data visualization & advanced chart tricks: Excel Charts
★ My Online Excel Courses ► https://www.xelplus.com/courses/
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)
➡️ Join this channel to get access to perks: @leilagharani
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
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!
#excel
4 سال پیش
در تاریخ 1399/05/02 منتشر شده
است.
206,033
بـار بازدید شده