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.

Two sets of intervals on Y axis
 

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.

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?

"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.


.

Two sets of intervals on Y axis
 

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.