Attractive Chart Designs in Excel: Create a Bi Directional Bar Chart

This video is a part of the excel chart design series. In the series, we will create attractive and innovative chart designs utilisng the amazing and easy to apply excel features. This video helps you to create a bi directional bar chart that you can use to compare two sets of data.

[@MrDhunpagla]

Shandar 👌👌👌👌👌

[@muralidharannatarajan4251]

Super❤

[@kokkiangng2846]

Clear instruction, I like this.
Wonder if the width between series can be adjusted and also if cluster series can be created in this bi directional bar chart.

[@Nori-mr9mw]

clear instruction, thank you, so basically excel doesn't have bi-directional, mirror chart or wtf it is

[@cassandrashelton7361]

When I select 1st series, instead of highlighting a column, it highlights the entire row including a, b, c, d, e and f

[@akhiljain7382]

I feel there is a problem with the horizontal axis labeling. center should be 0 and then scaling should run both ways.

[@premiertraininghub]

Thats not a problem for the output we are looking for. You do not need to show the horizontal axis labeling as the values are depicted by data labels. So just hide the axis as there is no need to put axis on your chart or presentation.

[@sallyho146]

@@premiertraininghubif I want to stack sales and margin in one bar chart(clustered column?) and stack sales% and margin % in another clustered column. Basically side by side stacking Sales and Margin/ Sales% and margin%, how do I do that? When I selected stacked column for Sales and Margin under ‘Chart Type’, all changed to stacked column. Please help. Thank you!