We would like to have the scale on our graph vary according to the data.  How do we do this?

Steps to Accomplish

You can vary the minimum and maximum on both the X and Y axes on your graph.  For our example, we will use a compaction graph and change the Y axis to vary based on the data.

1. In Report DesignGraphsselect the graph to modify.
2. On the toolbar, click the Properties button.
3. Go to the Dependent Data tab.
4. Delete the numbers in Minimum Value and Maximum Value.  

   Doing just this will vary the scale according to the data plotted:

   

   But it could look nicer.  You will notice the the largest and smallest values are on right on the top and bottom of the grid.  It will look better if there is a gap between the data and the edges of the grid.  Also, the numbers along the left side might look better rounded off.

5. To insert a gap, enter a number in Axis Offset: Minimum Side and Axis Offset: Maximum Side.  This property will remove the specified dimension (inches or millimeters, depending on the units of the report page) from the Data Frame.  We want a gap of 1/4" and entered 0.25 in both fields.
6. To round off the numbers of the left side we entered 1 in Round Minimum down to nearest and Round Maximum up to nearest.

   This looks better: