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.
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.
@@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!
Shandar 👌👌👌👌👌
Super❤
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.
clear instruction, thank you, so basically excel doesn't have bi-directional, mirror chart or wtf it is
When I select 1st series, instead of highlighting a column, it highlights the entire row including a, b, c, d, e and f
I feel there is a problem with the horizontal axis labeling. center should be 0 and then scaling should run both ways.
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.
@@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!