Intersection of the x and y axes at zero
Solved
Lilas
-
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?
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 réponses
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.
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.
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...
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...
"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)
--
Retirement is great! Especially in the Caribbean ... :-)
Raymond (INSA, AFPA, CF/R)
In Excel 2007 at least:
Right-click on axis (either X or Y) -> Format Axis... -> Axis Options -> Minimum -> FIXED = 0
Hoping it works!
Right-click on axis (either X or Y) -> Format Axis... -> Axis Options -> Minimum -> FIXED = 0
Hoping it works!
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.
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.
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.
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.
Yes!! I'm finally getting somewhere!! Thanks everyone! I can even maintain the appearance of a curve with the smoothed scatter plots, perfect!