Subscribe
The new Microsoft Excel misrepresents data by default
The default graphs were hideous at best, but now, thanks to a focus-group-tested and user-centric decision probably made by marketing drones without a brain: Microsoft Excel deliberately misrepresents data, because it turns out, users didn’t like empty cells in bar-graphs… idiots :-).
Update: to change this non-sensical idiotic default: select the range, open VBE and type “activecell.formatconditions(1).percentmin = 1” in the immediate window