Sep 03 2019 12:52 PM
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
Sep 03 2019 03:05 PM
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.