How do I change where category x axis crosses the 2nd y axis?
 

I'm trying to get the x axis to cross the y axis at zero for both the primary
and secondary y axis. However, since both sets of data points has negative
figures the x axis crosses the secondary y axis at a negative number. What
am I doing wrong?

How do I change where category x axis crosses the 2nd y axis?
 

On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the primary
and secondary y axis. However, since both sets of data points has negative
figures the x axis crosses the secondary y axis at a negative number. What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the
same proportion with respect to their zeroes. So if the primary Y axis
goes from -5 minimum to +10 maximum, and the secondary Y axis must have
a maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

How do I change where category x axis crosses the 2nd y axis?
 

The primary X axis has no connection to the secondary Y axis. Del points out
correctly that you need to make sure the Y axis scale parameters are related
by their ratios. I have some VBA code on this web page that will align the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

How do I change where category x axis crosses the 2nd y axis?
 

Thank you both for your replies. It was exactly what I needed.


"Jon Peltier" wrote:

The primary X axis has no connection to the secondary Y axis. Del points out
correctly that you need to make sure the Y axis scale parameters are related
by their ratios. I have some VBA code on this web page that will align the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

How do I change where category x axis crosses the 2nd y axis?
 

I tried to to the calculation as per your email, but I still can't get it to
align both axes at 0.. Can you please let me know where I input the code you
provide on your website?

Thanks.

"Jon Peltier" wrote:

The primary X axis has no connection to the secondary Y axis. Del points out
correctly that you need to make sure the Y axis scale parameters are related
by their ratios. I have some VBA code on this web page that will align the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

How do I change where category x axis crosses the 2nd y axis?
 

This blog entry ought to help explain it:

http://peltiertech.com/WordPress/200...e-elses-macro/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AR" wrote in message
...
I tried to to the calculation as per your email, but I still can't get it
to
align both axes at 0.. Can you please let me know where I input the code
you
provide on your website?

Thanks.

"Jon Peltier" wrote:

The primary X axis has no connection to the secondary Y axis. Del points
out
correctly that you need to make sure the Y axis scale parameters are
related
by their ratios. I have some VBA code on this web page that will align
the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the
same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.

How do I change where category x axis crosses the 2nd y axis?
 

I got the code from previous link and pasted it into my Chart sheet, however
I think what complicates things is that I have already 2 primary data set and
I guess I need to enter the code for the 2nd as well?

"Jon Peltier" wrote:

This blog entry ought to help explain it:

http://peltiertech.com/WordPress/200...e-elses-macro/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AR" wrote in message
...
I tried to to the calculation as per your email, but I still can't get it
to
align both axes at 0.. Can you please let me know where I input the code
you
provide on your website?

Thanks.

"Jon Peltier" wrote:

The primary X axis has no connection to the secondary Y axis. Del points
out
correctly that you need to make sure the Y axis scale parameters are
related
by their ratios. I have some VBA code on this web page that will align
the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the
same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.

How do I change where category x axis crosses the 2nd y axis?
 

Thanks for your help, BTW.. sorry

"Jon Peltier" wrote:

This blog entry ought to help explain it:

http://peltiertech.com/WordPress/200...e-elses-macro/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AR" wrote in message
...
I tried to to the calculation as per your email, but I still can't get it
to
align both axes at 0.. Can you please let me know where I input the code
you
provide on your website?

Thanks.

"Jon Peltier" wrote:

The primary X axis has no connection to the secondary Y axis. Del points
out
correctly that you need to make sure the Y axis scale parameters are
related
by their ratios. I have some VBA code on this web page that will align
the
axes for you:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Del Cotter" wrote in message
...
On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:

I'm trying to get the x axis to cross the y axis at zero for both the
primary
and secondary y axis. However, since both sets of data points has
negative
figures the x axis crosses the secondary y axis at a negative number.
What
am I doing wrong?

You must make sure the two Y axes have maximum and minimum set to the
same
proportion with respect to their zeroes. So if the primary Y axis goes
from -5 minimum to +10 maximum, and the secondary Y axis must have a
maximum of +4, then set its minimum to be -2. And so on.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.