Move x axis labels to bottom of chart with only one click

Kutools for Excel

If you create a column or line chart with both positive and negative values, the x axis labels will be located on the zero line in the middle of chart, for reading the data more intuitive and easily, you should move the x axis labels to bottom of the chart. With Kutools for Excel’s Move X-axis to Negative/Zero/Bottom utility, you can solve this job with only one click in Excel.

Move x axis labels to bottom of chart in Excel

Move x axis labels to bottom of chart in Excel

For moving the x axis labels under the negative numbers at bottom of the chart, please do as this:

1. Click to select the chart that you want to move the x axis labels, and then click Kutools > Charts > Chart Tools > Move X-axis to Negative/Zero/Bottom, see screenshot:

2. And then, a prompt box is popped out to tell you the operation has been done.

3. Then, click OK button to close the prompt box, and the x axis labels have been moved to the bottom of the chart, see screenshots:

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.