This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a line graph with percentage values between -36% and 50% for various periods. The X axis are the periods and the Y axis is the percentage for each period. When I created a line graph, the X-axis appears in the middle of the graph at value 0%.
How do I move the X-axis to the bottom of the graph? I appreciate your help.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Click to select the Y axis and then right click it and select format axis.
At the bottom of the display, it says "Horizontal axis crosses"
Select the radio button for axis value and enter -40 in the box.
Answer accepted by question author
Right-click a value axis label and select Format Axis... from the context menu.
Under Horizontal axis crosses, select Axis value, and enter a suitable value in the box, e.g. -40% (or -0.4).
Click OK.
This caused an even stranger issue ... I want my data centered around 0 (so to speak) so a value of 0 would cause a bar of o height to be drawn. However, now that my "horizontal cross-over" is at the bottom (-6 in my case) a value of 0 causes a bar of height 6 to be drawn!!! This is screwed up!
Thank You! This was the answer I was searching for amongst the noise.