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