Prev: new to excel 2007 how to chart this data
Next: Cluster Stack Column Line Chart in Windows vs Mac
From: Two sets of intervals on Y axis Two sets of intervals on Y on 31 Mar 2010 12:49
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.
From: Luke M on 31 Mar 2010 13:24
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
axis(a)discussions.microsoft.com> wrote in message
news:89E4692A-FF05-4EEC-A285-1C6069D0FCA0(a)microsoft.com...
> 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.


From: Two sets of intervals on Y axis on 31 Mar 2010 15:45
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/ChartsHowTo/PanelUnevenScales.html
>
> --
> Best Regards,
>
> Luke M
> "Two sets of intervals on Y axis" <Two sets of intervals on Y
> axis(a)discussions.microsoft.com> wrote in message
> news:89E4692A-FF05-4EEC-A285-1C6069D0FCA0(a)microsoft.com...
> > 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.
>
>
> .
>
From: EricG on 31 Mar 2010 16:01
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.
 | 
Pages: 1
Prev: new to excel 2007 how to chart this data
Next: Cluster Stack Column Line Chart in Windows vs Mac