How to: Change the Scale of a Chart (Report Builder)

By default, the minimum value for each axis is 0 and the maximum value for each axis is the highest value returned in the data.

To change the scale

1. In Report Builder design mode, right-click anywhere on the chart.

2. Click Chart Options.

3. Select the X axis or Y axis tab.

4. In the Minimum text box, enter the lowest value for the scale.

5. In the Maximum text box, enter the highest value for the scale.

6. Click OK.

See Also

Concepts

Working with Charts (Report Builder)
Formatting a Chart (Report Builder)

Other Resources

Chart Options Dialog Box (X Axis Tab) (Report Builder)
Chart Options Dialog Box (Y Axis Tab) (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance