Creating a Chart with a Broken Axis

This was a question that was posted by someone in 2009 that I'm trying to figure out today in iWork Numbers:


"I'm a research scientist and would like to use numbers to chart my data. The problem is, oftentimes some data represents a significant outlier, or is some positive control that will always be much higher than the other conditions. Is there anyway to "break" the axis of a chart?


For example say I have values of 6, 13, 14 and 150. If I graph these, the 150 will far and away dominate the graph, and I'll lose an appreciation of the other values, even if there are significant differences. Is there a way to have the axis display from 0-20, then break and jump up to show 100-200? Its a very common practice, but most software tends to ignore it (the excel workaround is a huge pain)."


Can anyone address this? Thanks!

MacBook Pro with Retina display

Posted on Feb 20, 2018 8:11 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating a Chart with a Broken Axis

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.