Excel charting

[jperry]

Is there a way to manually adjust Y-axis numbers to
account for a wide range of numbers, e.g. two series of
numbers below 20, but another series in the thousands,
thus eliminating most of the range inbetween?

 

[Andy Pope]

Hi jperry,

You can either put the data series with values in the 000's on the
secondary Y axis.

Another way would be to break the Y axis. Check Jon's page for and
example, which include links to other examples.
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy