excel graphs - combination? white line?

%3CLINGO-SUB%20id%3D%22lingo-sub-2312531%22%20slang%3D%22en-US%22%3Eexcel%20graphs%20-%20combination%3F%20white%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312531%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20just%20saw%20a%20report%20that%20had%20a%20graph%20in%20it.%26nbsp%3B%20What%20was%20different%20was%20the%20vertical%20numbers%20were%201%2C2%2C3%2C4%2C5%2C20%2C21%2C22%20between%205%20and%2020%20there%20was%20a%20white%20space%20gap%20line%20all%20the%20way%20across%20than%20it%20continued%20with%2020%2C21%2C%20etc.%26nbsp%3B%20This%20looked%20like%20they%20were%20able%20to%20truncate%20the%20graph%20and%20restart%20it%20to%20emphasis%20a%20gap%20in%20the%20vertical%20numbers.%26nbsp%3B%20I%20have%20not%20found%20how%20to%20do%20this.%26nbsp%3B%20Can%20anyone%20tell%20me%20how%20to%20do%20this%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313214%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20graphs%20-%20combination%3F%20white%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042207%22%20target%3D%22_blank%22%3E%40micro9901%3C%2FA%3E%26nbsp%3BI'm%20not%20aware%20of%20any%20feature%20in%20Excel%20that%20can%20do%20this.%20But%20if%20you%20have%20photo%20editing%20program%20you%20can%20copy%20the%20graph%20into%20it%20and%20create%20whatever%20you%20want%20from%20it.%20In%20the%20attached%20picture%20the%20%26nbsp%3Bgraph%20at%20the%20top%20come%20out%20of%20Excel%2C%20and%20the%20one%20below%20is%20%22edited%22%20(not%20very%20pretty%20I%20must%20admit).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-01%20at%2010.33.42.png%22%20style%3D%22width%3A%20534px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277248i532C01A86B39C040%2Fimage-dimensions%2F534x418%3Fv%3Dv2%22%20width%3D%22534%22%20height%3D%22418%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-01%20at%2010.33.42.png%22%20alt%3D%22Screenshot%202021-05-01%20at%2010.33.42.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313966%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20graphs%20-%20combination%3F%20white%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042207%22%20target%3D%22_blank%22%3E%40micro9901%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20'fake%20it'%20with%20a%20stacked%20column%20chart%20which%20is%20actually%20plotted%20against%20a%20hidden%20secondary%20axis%20whilst%20showing%20the%20values%20using%20labels%20and%20an%20offset%20primary%20axis.%3C%2FP%3E%3CP%3EShow%20as%3A%3D%20Values%20-%20cut%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277293iDDED3FE5906DA5A2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I just saw a report that had a graph in it.  What was different was the vertical numbers were 1,2,3,4,5,20,21,22 between 5 and 20 there was a white space gap line all the way across than it continued with 20,21, etc.  This looked like they were able to truncate the graph and restart it to emphasis a gap in the vertical numbers.  I have not found how to do this.  Can anyone tell me how to do this?

Thanks

 

3 Replies

@micro9901 I'm not aware of any feature in Excel that can do this. But if you have photo editing program you can copy the graph into it and create whatever you want from it. In the attached picture the  graph at the top comes out of Excel, and the one below is "edited" (not very pretty I must admit).

Screenshot 2021-05-01 at 10.33.42.png

@micro9901 

You could 'fake it' with a stacked column chart which is actually plotted against a hidden secondary axis whilst showing the values using labels and an offset primary axis.

Show as:= Values - cut

image.png

@micro9901 

Here How to break chart axis in Excel? (extendoffice.com) is step by step instruction and here Broken Y Axis in an Excel Chart - Peltier Tech is why breaking an axis is a bad idea with alternatives.