Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


MS Excel axis labels overlap in charts (what can you do about it)

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.

YouTube Stop the Axis Labels overlapping the chart

Watch, like, subscribe

As shown below, the April label overlaps the data for the first bill.

axis labels overlap

Stop Labels overlapping chart

There is a really quick fix for this.

As shown below:

  1. Right click on the Axis
  2. Choose the Format Axis option
  3. Open the Labels dropdown
  4. For label position change it to ‘Low’
axis labels overlap

The end result is you eliminate the labels overlapping the chart and it is easier to understand what you are seeing .

axis labels overlap

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.

Change the invert if negative colour in Excel charts

Turn off automatic date and time grouping in Excel Pivot Tables

Date Axis in Excel Chart is wrong

Chart Data Table number formats not working