How to modify the axes labels of a chart

On Format Chart, complete the following steps:

1	You can specify the title of value or y-axis for a chart. You can also specify the title for an additional y-axis, if the chart contains more than one.

2	To display labels, select Show labels. To hide labels, deselect Show Labels.

3	To rotate the labels, specify a degree of rotation in the Labels Angle field.

4	To stagger labels, select Stagger Labels.

If label names are too long, or if the chart looks too crowded when you display all the labels, you can use Interactive Viewer to specify which labels to skip so that only the other labels appear on the chart. To skip labels, set the Interval value at which labels should appear. For example, to show every other label, use an Interval value of 2. To show every fifth label, use an Interval value of 5, and so on.You can also modify the font properties for labels by choosing Label Font. The example in Figure 8-30 shows a chart on the left with staggered labels, and one on the right with rotated labels.

Figure 8-30

Staggered labels and rotated labels

Modifying scale

You can modify the scale of the value axis using Interactive Viewer to fit the data that the axis displays. Category axes do not support scale changes. The scale determines the range of values on a linear, logarithmic, or date-and-time axis. You can use the axis scale to change the following settings:

Minimum and maximum values for an axis

Step interval

Step Interval is the interval between each value on the value axis or the distance between major grid marks.

To set the scale of the y-axis, on Format Chart type values for minimum, maximum, and step interval in the Value (Y) axis area. The chart on the left in Figure 8-30 uses a scale between 0 and 240000 and a step value of 40000.