Excel Mastery: Stunning Comparison Bar Chart!
RBX Excel videos RBX Excel videos
2.82K subscribers
6,933 views
102

 Published On Oct 3, 2022

Unveiling Excel's Dynamic Comparison Bar Chart!

Join me in creating an exceptional comparison bar chart in Excel, showcasing an innovative design where bars extend from the center to both sides for easy comparison.

This step-by-step tutorial guides you through crafting this stunning chart. Utilizing a source table with two columns, we'll delve into creating helper columns crucial for constructing the chart. Learn how to form a stacked bar chart, including invisible series for the left, right, middle, and rounded edges, plus integrating a scatter plot to place images precisely within the bars.

Discover the art of formatting the chart, concealing unnecessary elements, and adding round edges for an elegant finish. Witness the strategic addition of scatter plots and images, revolutionizing the visual impact of your comparison bar chart.

Don't miss this insightful guide to creating a dynamic, picture-enhanced bar chart for effective side-by-side comparison!

Download link to the Excel file used in the video: https://drive.google.com/uc?export=do...

0:00 - Intro
0:44 - The source table
2:19 - Inserting and formatting the bar chart
4:38 - Adding the round edges
5:24 - Adding the data labels
6:21 - Adding the scatter plot
9:02 - Creating the pictures
10:40 - Place pictures on your scatter plot

show more

Share/Embed