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

In this tutorial we'll create an Excel Clustered Column Chart based on a real-life example. This Excel column chart has clustered and overlapped bars. It's basically a column chart that's overlapping another column chart in Excel.

⬇️ Download the chart template here: https://pages.xelplus.com/covid-chart-file

I'll also show you some additional tricks how you can make your Excel bar chart stand out from the rest. This technique is really simple but has a very powerful effect. It makes the difference between a "nice" Excel dashboard to a "great" Excel dashboard. This technique works with ANY Excel version. This way you'll create better Excel reports by improving your existing charts with a few smart tweaks.

What's Inside:
A tutorial on creating an advanced clustered column chart in Excel, featuring overlapping bars.

Key Highlights:
Chart Setup: Beginning with a basic clustered column chart using provided data.
Adding Background Bars: Techniques for adding background series to the chart for a layered effect.
Axis and Series Adjustments: Tips for managing secondary axis and arranging series for optimal visibility.
Color Customization: Using PowerPoint's eyedropper tool to match chart colors accurately.
Final Touches: Adjusting gap width, adding data labels, and customizing the legend for a polished look.

The chart is called "The New Normal Caused by COVID-19". It was published in a Udemy report about the impact of the pandemic on the country's workforce: https://research.udemy.com/portrait-of-a-pandemic-at-work/

00:00 How To Create a Professional Clustered Column Chart in Excel
05:23 How To Use Eyedropper in PowerPoint to Identify the Color Code
07:38 Adjusting chart Gap Width, Add Data Labels and Legend of Excel Chart
09:05 Use Textbox Instead of Excel Chart Title

More videos on Excel chats and visualizations: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ

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

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 #charts