Forum Discussion
How Do I Insert a Break in the Y Axis in Microsoft Excel?
Greetings, I have a data set that I am wanting to represent in Microsoft Excel in a column chart. There are two data series. One series has small numbers (1,1,1,1), and the other series has a ran...
spstelly I see this post is from 2019, but I also ran into this issue. What I did was created two charts. However, with the second chart (that housed the larger dataset), I selected "no fill" on the Shape Fill Format, and then made sure that the the Y axis were both equal distances so the gridlines would match, then I copy and paste it on top of the first chart with the smaller numbers. It works. Note that this is simply for presentation purposes. Updating the data may require you make further formatting changes.
