Customizing the Chart Axes

In most cases, the default formatting of the X-axis and Y-axis will be fine. But there are times when you will want to customize the axes to fit your reporting requirements. You can do things like turn the gridlines on or off, set the minimum and maximum value ranges, and set the formatting of the data values. The Axes tab on the Chart Expert, shown in Figure 12-11, gives you many options for making these changes.

Figure 12-11. Customizing a chart’s axes.

The Axes tab is broken into three sections. Each section controls a different part of the chart. The Show Gridlines section determines which axis the gridlines are shown at. They can be displayed along the major or minor axes. The type of chart you are displaying determines which gridlines are available.

The Data Values section sets the labels along the axis. The Auto Scale option is used when there are so many labels to display that they become hard to read. Turning this option on decreases the number of labels and this makes them easier to read. The Auto Range option sets a default range by evaluating all the possible values being charted. You can set the range by un-checking the Auto Range option and setting the minimum and maximum values manually. The Number Format drop down box lets you specify the number of decimals and whether the value should appear as a number, currency or percentage.

The Number of Divisions section sets the number of divisions along the data axis. You can set the Manual option to increase or decrease what Crystal Reports calculates to be the optimal number.