Move excel chart horizontal axis to bottom - below negative values

How can I move horizontal axis to the bottom in Excel chart, when there are negative values ? What should I do to move an axis below the negative values in chart ?
12 Apr 2021 at 05:24 PM
0pnshow more
NicoleNicole
Hi,

To move horizontal axis to the bottom of Excel chart, you have change the format of axis. For example, when your chart looks like this:


excel chart negative values move horizontal axis middle

Click on horizontal axis with right mouse button to display the menu and choose Format Axis:

excel chart format horizontal axis change position

Then in Labels section, change Label Position to Low:

excel chart negative values horizontal axis position move to bottom

After the change of label position, the chart should look like:

excel chart negative values move horizontal axis to bottom

19 Apr 2021 at 11:45 AM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us