This is a better Jon Peltier link:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

If that doesn't work, try using a logarithmic scale on the Y axis.

HTH,

Eric

"Two sets of intervals on Y axis" wrote:

Hi,

On an XY scatter chart, how can I have two sets of intervals for the Y axis
without doing a secondary scale? My data varies greatly and does not show
the trend for some of the categories.

Thanks.