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.


How to make a smooth line chart in Excel

When you are building a line chart in MS Excel, you may find that the jagged changes in direction don’t give you the look you want. So below although both charts are exactly the same, you may prefer the look and feel of the smooth lined chart. So how do you make a smooth line chart in Excel?

How to make a smooth line chart in excel

The process is very simple as there is a tick box for that (as with everything in Excel whatever you want is there- you just need to find it).

So as shown below, to make a smooth line chart in MS Excel, you would:

  • Right click on the jagged line;
  • Choose the Format Data Series
  • Choose the Fill and Line option (pouring bucket)
  • At the bottom tick the Smoothed Line option.
How to make a smooth line chart in excel

That’s it. Now your line will have a smooth changeover from one point to another.

Learn more about charting in our online MS Excel charting course (based on Office 365 Excel).

Want to learn more about Microsoft Excel in general? If you prefer live courses and live in South Africa look at the MS Excel training courses available. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

How to get Excel Chart Columns with no gaps