Tightening up range in a Line Chart

D

Dano

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top