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).
Table of contents
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.
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.
You can do this to as many slices as you want.
YouTube Explode one section of an Excel pie chart
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.