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 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'

2. 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!


Explode one section of an Excel pie chart

Pie Charts are a very popular method of visualising how much an item makes up of a total. Within Pie Charts you can make the ‘slices’ explode outwards. We don’t find this very useful. We do however like to explode one section of an Excel pie chart to emphasise it (see YouTube clip below).

YouTube Explode one section of an Excel pie chart

Pull out 1 slice of a pie chart

If you right click on the Pie Chart and choose the Format Data Series you will see that you can choose to explode all the slices (Pie Explosion below). You can also change the angle of the slice.

Explode one section of an Excel pie chart

In order to explode only 1 slice, it is as simple as:

  • Click on the particular slice until only it is activated.
  • Click, hold and drag it out as far as you want. pie-charts

You can do this to as many slices as you want.

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.

Excel waterfall chart template