To edit categorical scale range
main topic
    example     see also 

1    Double-click the scale.

2    Click the Scale tab.

3    Under Ticks for Innermost Displayed Category Labels, do one or more of the following:

·    Check Auto for Tick start to accept the default tick start point.

·    Uncheck Auto for Tick start to change the tick start point, then enter a value.

·    Check Auto for Tick increment to accept the default tick increment.

·    Uncheck Auto for Tick increment to change the tick increment, then enter a value.

4    Under Space Between Scale Categories, do one or more of the following:

·    Check Auto for Gap within clusters to accept the default cluster gap.

·    Uncheck Auto for Gap within clusters to change the cluster gap, then enter a value.

·    Check Auto for Gap between clusters to accept the default gap between clusters.

·    Uncheck Auto for Gap between clusters to change the gap between clusters, then enter a value.

5    Check Include empty cells to include empty cells in the graph.

6    Check Transpose value and category scales to transpose the variables that are plotted on each axis.

6    Check OK.