Two sets of intervals on Y axis

[Two sets of intervals on Y axis]

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.

 

[Luke M]

You mean like this?
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

--
Best Regards,

Luke M
"Two sets of intervals on Y axis" <Two sets of intervals on Y
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Two sets of intervals on Y axis]

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?

 

[EricG]

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