Chart values default to 0 on the bottom

[Bill]

I am creating a chart that will plot a series of numbers
that are relatively close to one another, say 5 numbers
that range from 6 to 7.1. When I chart it, the graph is
rather smushed (flat) looking because the chart insists on
having to start with 0 at the bottom. If I could have the
chart start at say 5, then the graph would have some more
up and down motion to it. Anyway to specify the axis
values of a chart? Thanks

 

[Debra Dalgleish]

To change the axis scale:

1. Double-click on the axis
2. In the Format Axis dialog box, select the Scale tab
3. Set a Minimum and/or Maximum
4. Click OK