Excel Mastery: Stunning Comparison Bar Chart!

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!

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

[simon.b.shongweshongwe]

Thank you very much for the tutorial video it is very informative and easy to follow. I have enjoyed very much will continue to learn from more of your videos.

[jennifersantosramirez]

When I try this with my data set I get negative values for the "west value" and "east value" columns which then throws off the x axis of the chart. Not sure how to fix. I followed the formulas. Any advice? My initial data values are smaller so maybe this is the issue.