Chart enter break from 0 to high #

[Gudkovich]

Hi all,

I have a chart that starts at 12K and goes up to 14 K, i would like the units jump to be 500, but i want the first # on the Y axis to be 0....so start with 0, then break, then 11,500, 12,000, 12,500....etc etc. Can anyone please show me how to do it

[#2]

Hello @Gudkovich ,

what you are after is called a "broken Y axis". A few years ago there were a number of tutorials on the web on how to achieve that, but since then the experts in data visualization have removed these tutorials because  a broken Y axis is hard to interpret and skews the picture. It's considered bad practice for charts.

In any case, a column chart should always start the Y axis at 0. If you use a line chart, you can start the Y axis with a higher number.