Bar charts are one of the most frequently used charts. To use them effectively to generate on-the-point graphs that deliver exactly the right message, however, requires some deeper understanding as well as a few tricks to make them more appealing.
I made a quick video that talks about:
1- The basic difference between clustered bar charts and stacked bar charts;
2- Why and when to use “Switch rows/columns” feature;
3- When to tweak the overlap and gap width between bars; and
4- How to make your own style of bars.
Here is the video:
You can also download the Excel file here.