Format Axis/ Scale and choose your preferred min & max values instead of the
automatically chosen ones.
--
David Biddulph

"Dano" wrote in message
...
This appears pretty basic, but I can not find a solution.

I am comparing two sets of similar data which are between 800 and
1600. The Line Chart I have created allows for data on the vetical
axis from 0 to 1800.

The differences in the data would be more efficiently demonstrated if
the range of the vertical axis were tightened to match the range of
the data.

Is there a way of doing this?

I am working in Excel 2007.

Thanks,

Dano