How do I add axis breaks to a category axis
In order to add an axis break to a category axis, you must first change the axis to linear. This requires changing the category data to integers, and then using the original category data as labels.
- Copy your category data to another column, then substitute linear, integer values for your categories.
- Change your axis scale in the Graph Properties dialog box Axis Tab, Scale panel, to Linear.
- Use the Tick Labels panel to change your labels from "Numeric" to the categories column data worksheet (see How do I use my own labels for tick labels).
- Now you can use the Axis Breaks panel and add and axis break to your graph.
|
| |