Hi,
I am trying to format a graph so that the x and y axis are identical to a Cartesian plain. So the Y axis crosses the X axis at the origin.
It seems that I can't get this to work.
I tried highlighting the Y axis and going to properties, then changing the min and max from auto to fixed. This solved the range for the Y axis, but I could not find a similar option in properties for the x axis.
The properties under the x - axis have the option:
Vertical axis crosses:
At category number: "0"
I put in "0" but it always changes it back to "1" and it doesn't move the location of the y axis to the 0 value on the x axis.
I am using excel 2010, does anyone know how to fix this?
Thanks
I am trying to format a graph so that the x and y axis are identical to a Cartesian plain. So the Y axis crosses the X axis at the origin.
It seems that I can't get this to work.
I tried highlighting the Y axis and going to properties, then changing the min and max from auto to fixed. This solved the range for the Y axis, but I could not find a similar option in properties for the x axis.
The properties under the x - axis have the option:
Vertical axis crosses:
At category number: "0"
I put in "0" but it always changes it back to "1" and it doesn't move the location of the y axis to the 0 value on the x axis.
I am using excel 2010, does anyone know how to fix this?
Thanks