If you build charts in MS Excel you may discover that some charts (especially ones that have positive and negative numbers) don’t look great as the axis labels overlap the data. As shown below, the April label overlaps the data for the first bill.
Stop Axis Labels overlapping
There is a really quick fix for this.
As shown below:
- Right click on the Axis
- Choose the Format Axis option
- Open the Labels dropdown
- For label position change it to ‘Low’
The end result is you eliminate the axis label overlap and it is easier to understand what you are seeing .
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.
