Many cut axes just because of Excel. And go to charting hell. Because when you cut you distort. And when you distort you lie. At least with your graph. The graphical change in your data is no longer proportional to the change in values. He explains it quite well with a demolished graph from the SportAuto magazine. Here is a positive example. From the German newspaper “Die ZEIT”. This newspaper is off the mark sometimes, too.
Die ZEIT, 2008-04-30, p. 37, market share of Deutsche Post (left) and number of letters in Germany in billions (right)
All my rules are observed. Time runs from left to right. Scale starts at zero. The graph is proportional to its values. No exaggeration. No gadgets. No unnecessary percentage signs. Letters in billions, not in single pieces.
In the same issue another good graph. Structure is shown top-down. Labeling where it belongs: next to the columns. At least for the values. I would have left out the series “andere” (“others”). The dots, too.
Die ZEIT, 2008-04-30, p. 78, academics in the automotive sector, for automobile manufacturers and suppliers