View original (French)

Intersection of the x and y axes at zero

Solved
Lilas -  
 Lilas -
Hello,

I created a line graph in Excel, my y-axis goes from 18 to 300 and my x-axis from 1 to 30.

I would like the intersection of the axes to be at zero instead of at 18/1, but without modifying the data in my spreadsheet.

I tried using the axis options/intersection of the vertical axis, but of course, I can only enter a number between 1 and 30.

Do you have a solution?

8 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    If I understand correctly, since Excel 2003 with a Line chart,
    to make the first data point align with the Y-axis (instead of pointing slightly to the right), you need to "uncheck" the box "The Y-axis intersects the X-axis."
    It's in the Scale tab of the X-axis Format.
    5
  2. Lilas
     
    Thank you for your responses,

    Theo: I am on Excel 2013, in "formatting, axis options" for the x-axis there is no "minimum, fixed" option available.

    Raymond: indeed, it’s not from 1 to 30 but “enter an integer number from 1 to 31999” that appears when I try to enter my infamous zero.

    Tontong: thank you, I also did not find this box in Excel 2013 but thanks to your indications I managed to set the y-axis to zero.

    So my problem is the same: the x-axis starts at 1 and not at zero.

    For the y-axis I have the "minimum limit, maximum limit" options you mentioned Theo, but not for the x-axis...
    2
  3. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    "I tried through the axis/vertical axis intersection options, but of course I can only enter a number between 1 and 30" Oh, really? That's new! Explain yourself better ...

    --
    Retirement is great! Especially in the Caribbean ... :-)
    Raymond (INSA, AFPA, CF/R)
    1
  4. Theo.R Posted messages 585 Status Member 31
     
    In Excel 2007 at least:

    Right-click on axis (either X or Y) -> Format Axis... -> Axis Options -> Minimum -> FIXED = 0

    Hoping it works!
    0
  6. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    With a "Curve" type graph, the x-axis is a category axis, and it cannot start at 0. The labels are 1, 2, 3... but they could be Riri, Fifi, Loulou...
    In order for the X-axis to start at 0, a scatter plot is needed.
    0
  7. Lilas
     
    Hello,

    Indeed, the axis is offset at the zero point, but "riri, fifi and loulou" remain 1,6,11,... which is also something I would like to change. And it's a pity that we can't keep the curve instead of the points.
    Thank you anyway.
    0
  8. Lilas
     
    Yes!! I'm finally getting somewhere!! Thanks everyone! I can even maintain the appearance of a curve with the smoothed scatter plots, perfect!
    0