Moving X-axis labels at the bottom of the chart below negative values in Excel

 By default if you insert a bar chart or line chart, the x-axis labels are stuck at 0 position of the axis. This usual behaviour gets in the way especially if you have negative values in the data that are plotted against y-axis in which case x-axis labels will overlay the lines or bars. Have a look at the following! Classical case of a mess:

x-axis label 1

Hating it right? It sure is something to hate. But it is an easy fix if you know it. So how to fix it?

Simply right click on x-axis labels > click format axis. Formatting panel will open at the right. Scroll down to labels options > expand them if you have to and from label position drop down select Low.

x-axis label 2

Tada! Now as it is out of the way your chart can flex and update as the data changes without any visual disruption!

x-axis label 3

Trang

Powered by Blogger.