Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

How can you combine unrelated Excel features to create a visualization your boss will be proud of? That's what I try to do using Excel's FREQUENCY function, Form Controls, MAX formula & 3D models.

My solution is an Excel dynamic bar chart with icons. It's not your standard bar chart. It's an Excel chart that's conditionally formatted:
The highest value is conditionally formatted with an icon. The icons are automatically hidden for the remaining bars. We use a trick to get it conditionally formatted. There are a lot of Excel chart tricks used here if you pay close attention. I'll also show you how you can use 3Dmodels in PowerPoint at the end of the video.

This is solution entry to Oz du Soleil's #ExcelHash competition.

The entire Playlist is here: https://www.youtube.com/playlist?list=PLHrPHBbDHgT0UnY1qb36YZrBwpWNJX8Lx

Other ExcelMVPs in the Excel Hash challenge are:

Mike Girvin - Excel Is Fun
Bill Jellen - MrExcel
Mynda Treacy - MyOnlineTrainingHub
Jon Acampor - Excel Campus
Oz du Soleil - Excel on Fire


Links to related videos:
Learn Index Match: https://youtu.be/F264FpBDX28
Charts basics: https://youtu.be/DAU0qqh_I-A

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

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: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Music: Italian Afternoon by Twin Musicom is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/)
Artist: http://www.twinmusicom.org/


#ExcelHash #MsExcel