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.
Table of contents
YouTube Stop the Axis Labels overlapping the chart
Watch, like, subscribe
As shown below, the April label overlaps the data for the first bill.
Stop Labels overlapping chart
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 labels overlapping the chart 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.
Related
Change the invert if negative colour in Excel charts
Turn off automatic date and time grouping in Excel Pivot Tables