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.

You mean like this?
http://peltiertech.com/Excel/ChartsH...venScales.html

--
Best Regards,

Luke M
"Two sets of intervals on Y axis" <Two sets of intervals on Y
wrote in message
...
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.

Thanks for responding. It looks like the link that you provided is regarding
different types of scales (percentages and amounts). I have one type of
scale (amounts). The problem I have is that some categories have numbers in
the hundreds and other categories have amounts in the thousands. When I
create the chart, the increments are in the thousands, which will not show
the trends of the smaller amounts. Is there a way to have some type of
incremental separation or "break" on the Y axis?

"Luke M" wrote:

You mean like this?
http://peltiertech.com/Excel/ChartsH...venScales.html

--
Best Regards,

Luke M
"Two sets of intervals on Y axis" <Two sets of intervals on Y
wrote in message
...
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.


.

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.