Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a cell reference as the axis value for Horizontal axis crosses | Charts and Charting in Excel | |||
Value (Y) axis crosses between categories and Secondary Value (Y) Axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel |