Master Business Charts in Excel with our course π
https://link.xelplus.com/yt-d-all-coursesLearn 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-fileWe'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-courses00: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/xelplusNote: 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
About the Site π
This site provides links to random videos hosted at YouTube, with the emphasis on random. π₯
Origins of the Idea π±
The original idea for this site stemmed from the need to benchmark the popularity of a video against the general population of YouTube videos. π§
Challenges Faced π€
Obtaining a large sample of videos was crucial for accurate ranking, but YouTube lacks a direct method to gather random video IDs.
Even searching for random strings on YouTube doesn't yield truly random results, complicating the process further. π
Creating Truly Random Links π οΈ
The YouTube API offers additional functions enabling the discovery of more random videos. Through inventive techniques and a touch of space-time manipulation, we've achieved a process yielding nearly 100% random links to YouTube videos.
About YouTube πΊ
YouTube, an American video-sharing website based in San Bruno, California, offers a diverse range of user-generated and corporate media content. π
Content and Users π΅
Users can upload, view, rate, share, and comment on videos, with content spanning video clips, music videos, live streams, and more.
While most content is uploaded by individuals, media corporations like CBS and the BBC also contribute. Unregistered users can watch videos, while registered users enjoy additional privileges such as uploading unlimited videos and adding comments.
Monetization and Impact π€
YouTube and creators earn revenue through Google AdSense, with most videos free to view. Premium channels and subscription services like YouTube Music and YouTube Premium offer ad-free streaming.
As of February 2017, over 400 hours of content were uploaded to YouTube every minute, with the site ranking as the second-most popular globally. By May 2019, this figure exceeded 500 hours per minute. π
List of ours generatorsβ‘
Random YouTube Videos Generator
Random Film and Animation Video Generator
Random Autos and Vehicles Video Generator
Random Music Video Generator
Random Pets and Animals Video Generator
Random Sports Video Generator
Random Travel and Events Video Generator
Random Gaming Video Generator
Random People and Blogs Video Generator
Random Comedy Video Generator
Random Entertainment Video Generator
Random News and Politics Video Generator
Random Howto and Style Video Generator
Random Education Video Generator
Random Science and Technology Video Generator
Random Nonprofits and Activism Video Generator