Can't get the x-axis to cross at value 0 for both y-axes

Programming and Web Development Forums - MS EXCEL - Microsoft Office Excel

Skip to content

Can't get the x-axis to cross at value 0 for both y-axes

MS EXCEL
Post a reply

    Next

  • 1. Rotating a line chart?
    Is it possible to rotate a line chart so it looks like a vertical chart rather than a horizontal chart? And if so, once it is rotated, can one still interact with the chart and it's data? Thank you.
  • 2. Creating a Chart in a C# Application...
    How does implementing an Excel Chart in a C# application work? Does the end user need to have the required dlls on their machines or can they be delivered with the main application? Thank you.
  • 3. HELP!!!!!!!!!! Y By X Chart with points.
    Hi, I am using Excel 2003 and I am trying to build a chart with the following info: Points 1 2 3 4 5 6 7 Variety 1 7.1 5.6 4.8 5.8 4.8 4.2 5.2 Variety 2 5.5 5.5 5.2 6.5 4.3 6.2 3.6 Variety 3 2.3 2.8 5.0 7.6 4.3 6.1 5.7 Variety 4 8.4 8.2 6.1 6.1 6.6 9.0 7.0 Variety 5 15.8 21.8 15.1 7.2 18.0 19.7 12.5 Variety 6 6.2 1.8 1.6 5.9 6.4 7.2 3.6 Variety 7 3.0 4.7 6.6 6.0 4.3 6.4 2.9 What I am trying to do is have the Variety 1 etc on the vertical axis and the point data on the horizontal axis from low to high. There are duplicat amounts in the point data but this is ok. I need the points data on the horizontal axis to be on a range from 0 to the highest. I need them to show up as dots, circles or diamonds, etc. I built a stacked column chart but this is not what I was looking for. Your help on this matter will be greatly apppreciated. If it cannot be done with Excel, then suggest some software that could help me do what I want. Thanks, Curt
  • 4. Large Plot (limits exceeded)
    I have collected two data points for 18 months, 24/7. Puts that at >157K. That is Station 1 & Station 2, date, time, reading1, reading 2. When I went to chart in Excel got the message that the width was limited to 255 in the chart. Any suggestion on how to display the data? XP, XL 2003. Thanks, Gregor
  • 5. Chart - Fixed Median Value
    Hi Folks - I have a chart based on the following data: State Salary RI 35000 CT 42000 NH 39000 VT 36000 ME 37000 The average salary for all states is 37800. I'd like to chart this data with the states on the x-axis and the salary amount on the y-axis. Here's the catch .. I'd like to chart the average state salary as a fixed horizontal line on the y-axis. Do-able? Thanks, Michael

Can't get the x-axis to cross at value 0 for both y-axes

Postby RGVyZWs » Wed, 19 Mar 2008 04:05:01 GMT 

Hello - 

I am working on an Excel chart with both a primary and secondary y-axis and 
only one x-axis.  The primary has positive and negative values.  The 
secondary has all positive values.  I am using the secondary as a rank (by 
selecting the box to invert values so the highest rank has a value of 1 and 
appears at the top of the secondary y-axis, where rank 25 is the lowest 
possible rank and appears at the bottom of the secondary y-axis), in theory 
where the x and y axes meet.  The x-axis is different points in time.  So 
this chart shows trends over time.

The issue I am having is the primary x-axis crosses the primary y-axis at 0 
(y-axis value), which is what I want.  However, the primary x-axis crosses 
the secondary y-axis at a value that is not the lowest value on the secondary 
y-axis.  In this case, since I am using it as a rank, it is not crossing at 
the lowest rank.  I am not showing the secondary x-axis associated with rank.

I don't have this issue if all of the values on the primary y-axis are 
positive.  In other words, the primary x-axis crosses at 0 on the primary 
y-axis and at the lowest rank on the secondary axis.

My question is, is there a way to fix my problem?  Is there an option where 
I can set the value where the primary x-axis crosses a value on the secondary 
y-axis?  I know I can set the value for Primary x-axis to primary y-axis - 
and do the same for the secondary x and y axes, but I'm not aware of a way to 
cross this primary - secondary boundary.

I imagine the graph's axes looking like a backwards 4 - the primary y-axis 
goes above and below the primary x-axis.  The primary x-axis is approximately 
in the middle.  The secondary y-axis is as high as the primary y-axis but 
only goes down to the x-axis (i.e., it does not extend below the x-axis).  Is 
this possible?

Something like this:

|            |
|_______|
|
|

Thanks!

- Derek
Top

Re: Can't get the x-axis to cross at value 0 for both y-axes

Postby Jon Peltier » Wed, 19 Mar 2008 04:39:41 GMT 

You have to fix the secondary axis so it goes as far negative as a 
proportion of its full scale as the primary axis does. You can do it 
manually or using a VBA procedure:

 http://www.**--****.com/ 

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

Re: Can't get the x-axis to cross at value 0 for both y-axes

Postby RGVyZWs » Wed, 19 Mar 2008 05:34:02 GMT

i Jon -

Thanks for the quick response.

I understand what you are saying in terms of having the primary and
secondary y-axes in proportion to each other, but I think the wrinkle in my
chart is I am using the secondary y-axis as a rank with the lowest rank at
the bottom where the y-axis meets the x-axis.

I completely agree with your suggestion if I were dealing with numbers going
in the same direction on both y-axes, but that is not the case here, since
you can't have a negative rank and I have rank in descending order with $
values in ascending order.

So my envisioned chart looks like this with $ as a bar graph (primary axis)
and rank as a line graph (secondary axis). I want the secondary y-axis to
cross / stop at the primary x-axis at x-axis value $0. If I have the rank
proportions to the $ amounts, it implies a $0 is not the bottom rank, which
is not always the case in my data set. I don't want the primary x-axis to
imply $0 is not ranked the lowest.

$100 | | Rank 1
| |
| |
$0 |_________|Rank 25
|
|
($100)|
Q1 Q2 Q3

- Derek

-----------------------


"Jon Peltier" wrote:

Top

Re: Can't get the x-axis to cross at value 0 for both y-axes

Postby Jon Peltier » Wed, 19 Mar 2008 06:20:14 GMT

didn't say plot numbers along the negative secondary Y axis, I was telling
you how to align the 0 point of each Y axis. If you don't want the negative
part of the axis to show, don't display any part of the axis (format: no
line), and add an XY series to the chart to serve as a fake axis:

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

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


"Derek" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


Top

Similar Threads:

1.Need PivotChart x axis to cross Y axis at minimum Y axis value 

I see an option to have x cross y at max y, but how can I say min y?

2.Value (Y) axis crosses between categories and Secondary Value (Y) Axis 

Hi all -

I have 7 series on my chart
Series 1 is column chart - may be area chart eventually (2007 data)
Series 2 is column chart 2008 data
Series 3 is column chart 2007 avg
Series 4 is a column chart 2008 avg
Series 5 is a line chart (32,0 benchmark)
Series 6 is a line chart (points to column chart for 2007 avg, I then
add text to right to explain the column)
Series 7 is a line chart (points to column chart for 2008 avg, I then
add text to right to explain the column)

I would like the column charts for 2007 and 2008 data to be flush to
the origin (12 data points each year)
I would like the benchmark line chart of 32 to span the chart area
from left to right (16 data points)

>From what I've read, the way to accomplish this, is to clear the tick
mark from Value (Y) axis crosses between categories when formatting
the x axis.

However, when I do that, the data point for 2007 closest to the origin
appears cut-off on left side of column

I more or less posted this information on Ozgrid a few days ago
(Ozgrid is now down until Nov. 13 according to the site). Andy Pope
replied that if I move the line charts to the Secondary Value (Y)
Axis, that would resolve the problem.

I must be doing something wrong. I did assign the line chart to
Secondary Value (Y) Axis and then cleared the tick mark on the x axis:
Value (Y) axis crosses between categories. However whatever datapoint
is closest to the Primary Y Axis disappears entirely

What am I doing wrong here?
Send a confidential e-mail for a sample copy of the workbook
Best regards,
-markc

3.why can't Y-axis cross the X-axis at zero 

Hi,

The problem I have is that the y axis crosses the x axis 
at 1 and when I try to change that to 0 under format 
axis>scale it returns a message saying "The Number must 
be between 1 and 31999, Try again bla bla.."

Is there anyway to change that?


Thanks,

John

4.Using a cell reference as the axis value for Horizontal axis crosses 

Is there any way of referencing a cell as the value in the "axis
value" area of the "Format Axis dialog box. I am currently entering a
number i.e. 2.5. I would like to be able to have this number change
when a user enterer a value in a cell?  Would it have to be VBA code
or is there another way?

5.X-axis to cross Y-axis at avrg Y-value 

Have been trying for ages to get the X-axis to cross the Y-axis at exactly 
the avrg Y-value - to see results above and below average. But I can't find a 
way to do it. Anyone?
(Tried recording a macro that takes the avrg value and pastes it into the 
field in the "Value (X) axis crosses at" field, but it pastes the formula 
rather than the number, and Excel can't handle a formula in that field...)

Thanks for any help

6. chart secondary axis crossing with x axis

7. How to insert X axis scale values next to axis and X axis grid lin

8. Should allow: "Value (X) axis crosses at *-MINIMUM-* value

Post a reply

Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 78 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group