Summary
Keywords
Full Transcript
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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
