MENU

Fun & Interesting

This Excel Chart will grab your attention (Infographic template included)

Leila Gharani 1,128,835 8 years ago
Video Not Working? Fix It Now

🔥 Create charts that wow your audience. Learn the secrets now—start today! 👉 https://link.xelplus.com/yt-g-special-charts-course Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards. ⬇️ Download the workbook here: https://pages.xelplus.com/special-chart-file We'll cover the dynamic aspect of the chart, highlighting the use of conditional formatting to emphasize the most significant data. This includes dynamically highlighting the weekday with the maximum number of users, ensuring the chart updates automatically with new data. The tutorial guides viewers on how to create shapes within charts and adjust them to prevent distortion, a key factor in maintaining the chart's visual appeal. Moreover, the video covers advanced techniques such as adding data labels, utilizing stacked column charts, and implementing conditional formatting for rounded column charts. This in-depth guide not only teaches how to visually enhance charts in Excel but also ensures that the data remains dynamic and responsive to changes. Note: This technique is a part of my online Dashboard course: https://www.xelplus.com/course/excel-dashboards/ 🌍 Join 400,000+ professionals in our courses ► https://link.xelplus.com/yt-d-all-courses 00:00 Why Create a Non-Standard Column Chart in Excel 01:48 Start with Basic Column Chart 02:44 Conditional Formatting of Excel Column Chart for MAX-Value 05:51 Create Round Shape for Excel Column Chart 07:45 Prevent Stretching of Round Shape in Column Chart 10:41 Add Data Labels to Excel Chart 12:45 Add Conditional Formatting to Rounded Column Chart This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel. Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well. After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized. As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart. ➡️ 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 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

Comment