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
Find us on Facebook AnswertabsFind us on Facebook Answertabs
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 twitter
2021 AnswerTabsTermsContact us