I am wondering if there is any way to have the Y-axis broken to account for two different ranges of values. For example, if I have Y values on a simple column graph of -90, -100, -110 and 90, 100, 110 and I want to put these on the same graph but I want the Y-axis scale to go from -90--110 then jump to 90-110, is this possible in EXCEL and if not can you recommend a software that will do this.
I searched for some links, but they could only provide broken y axis on one side of the break, and very tedious to make a lot of figures.
Any info would be greatly appreciated. Thanks.
I searched for some links, but they could only provide broken y axis on one side of the break, and very tedious to make a lot of figures.
Any info would be greatly appreciated. Thanks.