Stacked Column Chart with Broken Axis

[Shawn1888]

Good afternoon,

I'm looking at a variety of vehicle crash costs classified into 5 types: Minor ($0-$5k), Moderate ($5k-$10k), Serious ($10k-$20k), Major ($20k-$50k) and Severe ($50k+). My ultimate goal is to compare year over year cost data to show improvement. I've included a table below with some sample data. Whenever a single Severe accident takes place, the cost is so high that it makes any type of representation for the Minor accidents disappear completely from the table. What I'm hoping to do is a stacked column chart showing all 5 categories in each column resulting in one total cost for the month with a break at $1,000,000 resuming at $2,500,000 and another break at 5,000,000 resuming at 10,000,000.

I've looked up some videos to see how to take a single total value & create an axis break, but they don't cover how to do it as a stacked column.

	January 2019	January 2020	February 2019	February 2020	March 2019	March 2020
Minor	51100	21000	81000	59000	95500	73300
Moderate	242500	93000	532000	220000	700000	455000
Serious	425200	350000	425200	455000	700000	455000
Major	210000	0	210000	0	640000	0
Severe	4500000	0	4500000	0	4500000	0

Thanks for your time and help. I really appreciate it

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Andy Pope]

Consider alternative chart type rather than breaking the axis.

https://peltiertech.com/?s=panel+chart

Each panel can have it's own scaling and Total could be an additional panel.