Categories
Excel Training Hints & Tips

Pie Chart Segment

Pull out a segment in an Excel pie chart

Pie charts are great for visually showing categories. Occasionally we might want to emphasise a segment. To do this, we can pull out a pie chart segment!

1 – Create a Pie Chart

Start by selecting your data, going to the Insert tab along the Ribbon and choosing Pie from the Charts subgroup.

Insert Pie

 

 

 

 

 

 

2 – Drag a Segment

Click on the middle of the Pie Chart to select it. Now click and drag a segment out. In this example we wish to draw out the “Net Worth” pie chart segment.

Click Pie Then Drag Segment

 

 

 

 

 

 

 

 

You now have a Pie chart with a single segment emphasised.

Finished Pie

 

 

 

 

 

 

 

 

 

As you can see this is a very quick way to draw attention to a particular pie chart segment. Read on below for further information on working with pie charts and display options available.

Resources

Changing Excel chart types

Explode or expand a pie chart

 

 

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.