Excel Mastery: Stunning Comparison Bar Chart!

Published: 03 October 2022
on channel: RBX Excel videos

8,595

114

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

Watch video Excel Mastery: Stunning Comparison Bar Chart! online, duration hours minute second in high quality that is uploaded to the channel RBX Excel videos 03 October 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 8,595 times and liked it 114 visitors.