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. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Add label to Excel chart line

If you create line charts in Excel you may occasionally need to include labels to make it easier for the user to see what number the line is representing. Adding a label to an Excel line chart is very easy.

As shown below, you can create the chart and then right click on the line and choose ‘Add Data Labels’ and then ‘Add Data Labels’ again.

add-label-to-excel-chart-line

The labels are immediately put on the chart and Excel has ‘guessed’ that you wanted the values to appear. However, by right clicking on the labels you can customise what appears as labels. In the case below we have kept the values but note that we could use the series or category name. We also told Excel that the labels must appear above the line (Excel defaulted to the Right).

add-label-to-excel-chart-line

Resize multiple charts

Simple Gantt chart in Excel

Labels overlap series points