Create Chart with Broken Axis and Bars for Scale Difference - Simple Method

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:

Business Scenario: Showing headcount by departments and there are huge difference in headcount by department.

******Follow-up Consulting Services******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[adamjohari]

wish this was automated, rather than adjusting with images

[josephdesenclos]

You’re a life saver! Thank you so much!

[jacquelinegap]

Thank you so much! This just saved me! 🙏🙏🙏

[gimmifenomeno]

ahahaha I was not expected to have a paint lesson

[Briceflorent]

Great get around, thanks for you insightful video. But why don't just use the logarithmic scale in the axis option ?

[htunhtunoo]

how can I create a split / broken axis stacked column chart

[rishabhshar]

how to do it for the stacked bar chart

[dariuszspiewak]

It's a solution but it's brittle. Can be easily broken. Pity there is no native solution available... :(

[benitocamelo]

Thanks a lot for the help! It really help me!

[DurayStuffCrafts]

Is this method good for research publication figures??

[kellymcalister]

Thank you. Surprising that it takes this much manual effort. Excel should do better. Still, I appreciate you!

[AbhishekSingh-lutw]

but what about 1500 is infront of 1540

[Aichauer]

ask your boss for the think-cell add-in!😅

[shi__]

I thought...
so... just edit the image...
...

[AbhishekSingh-lutw]

We cannot cut copy paste that graph madam

[tittutalks]

Please don't waste precious time

[mdhasibreza]

Not a bad idea perhaps it helps sometime 😁

[SuelyPio]

I'm not even going to the complicated one.