Master Business Charts in Excel with our course 👉 link.xelplus.com/yt-d-all-cou...
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: pages.xelplus.com/special-cha...
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: www.xelplus.com/course/excel-...
🌍 Join 400,000+ professionals in our courses ► link.xelplus.com/yt-d-all-cou...
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: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
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