SOLVED
Home

How to add scale breaks in an Excel graph?

%3CLINGO-SUB%20id%3D%22lingo-sub-1179272%22%20slang%3D%22en-US%22%3EHow%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179272%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20add%20%3CSTRONG%3Escale%20breaks%3C%2FSTRONG%3E%20in%20an%20Excel%20graph%3F%3C%2FP%3E%3CP%3ELike%20this%3A%20(but%20per%20bar%20seperately!)%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rs-multipledatarangeschart-scalebreak%22%20style%3D%22width%3A%20411px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171644iE3D7F146887AA304%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22rs-multipledatarangeschart-scalebreak%22%20alt%3D%22rs-multipledatarangeschart-scalebreak%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1179272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1179302%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179302%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299401%22%20target%3D%22_blank%22%3E%40Ruben805%3C%2FA%3E%26nbsp%3BYou%20may%20want%20to%20try%20a%20logaritmic%20scale.%20Not%20exactly%20what%20you%20asked%20for%2C%20but%20than%20you%20could%20create%20something%20like%20this.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-18%20at%2013.42.05.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171648i5DB36B5F557E75CF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-02-18%20at%2013.42.05.png%22%20alt%3D%22Screenshot%202020-02-18%20at%2013.42.05.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1179359%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179359%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20response!%3CBR%20%2F%3EBut%20i'm%20really%20looking%20for%20scale%20breaks%20on%20one%20or%20two%20of%20the%20long%20bars%20in%20a%20graph.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1179371%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299401%22%20target%3D%22_blank%22%3E%40Ruben805%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%20some%20workarounds%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpeltiertech.com%2Fbroken-y-axis-in-excel-chart%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EBroken%20Y%20Axis%20in%20an%20Excel%20Chart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fksrowell.com%2Fblog-visualizing-data%2F2013%2F08%2F12%2Fhow-to-simulate-a-broken-axis-value-axis%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20Simulate%20a%20%E2%80%9CBroken%20axis%E2%80%9D%20Value%20Axis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181742%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181742%22%20slang%3D%22en-US%22%3EThank%20you%20for%20the%20response!%3CBR%20%2F%3E%3CBR%20%2F%3EFrom%20this%20I%20can%20conclude%20that%20it%20is%20probably%20not%20possible%20in%20Microsoft%20Excel.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181744%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20scale%20breaks%20in%20an%20Excel%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299401%22%20target%3D%22_blank%22%3E%40Ruben805%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20out%20of%20the%20box%2C%20only%20with%20some%20workarounds%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

 

How to add scale breaks in an Excel graph?

Like this: (but per bar seperately!)

Many thanks.

 

rs-multipledatarangeschart-scalebreak

5 Replies
Highlighted

@Ruben805 You may want to try a logaritmic scale. Not exactly what you asked for, but than you could create something like this.

Screenshot 2020-02-18 at 13.42.05.png

Highlighted
Thank you for your response!
But i'm really looking for scale breaks on one or two of the long bars in a graph.

Highlighted
Highlighted
Thank you for the response!

From this I can conclude that it is probably not possible in Microsoft Excel.
Highlighted

@Ruben805 

Not out of the box, only with some workarounds

Related Conversations
Alt+ Enter not working
Nikhil_Shetty in Excel on
1 Replies
Formule Si
Kevin13800 in Excel on
0 Replies
Multiple Conditional Formatting
Ray_Ray in Excel on
2 Replies
IF Function
Zaharyshka8 in Excel on
2 Replies
Changing Data Source
cjkim92 in Excel on
0 Replies
Convertion d'heure
Philaos-49 in Excel on
1 Replies