Chart values default to 0 on the bottom

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

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

Bill wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html