peltiertech.com › broken-y-axis-inBroken Y Axis in an Excel Chart - Peltier Tech Nov 18, 2011 · While a bar chart has the requirement (well, it often isn’t followed, to the detriment of the reader) that the value axis scale has to include zero, a line chart is not bound to zero. You could scale your axis from 5000 to 7000. Of course, while this doesn’t distort the values themselves, it exaggerates the variability within this range.