Bar vs Dot Charts (in Excel)

I often observe (on the web or in my students works) bar charts used inappropriately. What often happens is that bar charts are used with a non-zero baseline, which implies telling a visual lie.

Here I report a very simple example of how the issue emerges when drawing a chart in Excel and a possible solution (using a dot chart).

Disclaimer: this is quick post, apologies for typos and lack of clarity.

Continua a leggere