Home

Chart enter break from 0 to high #

%3CLINGO-SUB%20id%3D%22lingo-sub-835253%22%20slang%3D%22en-US%22%3EChart%20enter%20break%20from%200%20to%20high%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835253%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHi%20all%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20a%20chart%20that%20starts%20at%2012K%20and%20goes%20up%20to%2014%20K%2C%20i%20would%20like%20the%20units%20jump%20to%20be%20500%2C%20but%20i%20want%20the%20first%20%23%20on%20the%20Y%20axis%20to%20be%200....so%20start%20with%200%2C%20then%20break%2C%20then%2011%2C500%2C%2012%2C000%2C%2012%2C500....etc%20etc.%20Can%20anyone%20please%20show%20me%20how%20to%20do%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-835253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835624%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20enter%20break%20from%200%20to%20high%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835624%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402843%22%20target%3D%22_blank%22%3E%40Gudkovich%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhat%20you%20are%20after%20is%20called%20a%20%22broken%20Y%20axis%22.%20A%20few%20years%20ago%20there%20were%20a%20number%20of%20tutorials%20on%20the%20web%20on%20how%20to%20achieve%20that%2C%20but%20since%20then%20the%20experts%20in%20data%20visualization%20have%20removed%20these%20tutorials%20because%26nbsp%3B%20a%20broken%20Y%20axis%20is%20hard%20to%20interpret%20and%20skews%20the%20picture.%20It's%20considered%20bad%20practice%20for%20charts.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20any%20case%2C%20a%20column%20chart%20should%20always%20start%20the%20Y%20axis%20at%200.%20If%20you%20use%20a%20line%20chart%2C%20you%20can%20start%20the%20Y%20axis%20with%20a%20higher%20number.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Gudkovich
Occasional Visitor

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

1 Reply

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.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies