How to set axis break in numbers
I have my bar chart below, but the first series is way far away from the other series and dominates the chart, my problem is how to add an axis break at 5k and jump to 14k.
Could u address this, thx
Question marked as
Top-ranking reply
Tried to post this earlier. It spun for a long while. Trying again...
There is no built-in way to do it. A workaround would be this:
- Create a chart (which you already did)
- Copy/Paste it to create a copy of it
- On the first one, set the X axis min to 0 and max to 5K and set the number of steps to an appropriate number.
- On the second one, set the X axis min to 12K and max to 14K and set the steps so the distance (numerically) between gridlines is the same as the first chart.
- Remove some of the features of the second chart, such as the Y axis line, legend, and such.
- Move the second chart below/overlapping the first and adjust its horizontal size to make the grid lines be the same distance apart (physically) as the first one.
- Line the second one up with the first so it looks like one chart.
- Maybe do something to highlight the missing area (which I did not do in the screenshot below)
