{"id":2157,"date":"2015-02-03T10:43:57","date_gmt":"2015-02-03T10:43:57","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2157"},"modified":"2023-12-31T00:04:58","modified_gmt":"2023-12-31T00:04:58","slug":"pie-chart-segment","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/pie-chart-segment\/","title":{"rendered":"Pie Chart Segment"},"content":{"rendered":"

Pull out a segment in an Excel pie chart<\/strong><\/p>\n

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!<\/p>\n

1 – Create a Pie Chart<\/strong><\/p>\n

Start by selecting your data, going to the Insert tab along the Ribbon and choosing Pie from the Charts subgroup.<\/p>\n

\"Insert<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

2 – Drag a Segment<\/strong><\/p>\n

Click on the middle of the Pie Chart to select it.\u00a0Now click and drag a segment out. In this example we wish to draw out the “Net Worth” pie chart segment.<\/p>\n

\"Click<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

You now have a Pie chart with a single segment emphasised.<\/p>\n

\"Finished<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

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.<\/p>\n

Resources<\/h3>\n

Changing Excel chart types<\/a><\/p>\n

Explode or expand a pie chart<\/a><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[164,166,244,245,416],"class_list":["post-2157","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-edit-a-pie-chart","tag-emphasise-a-pie-chart-segment","tag-expand-a-segment","tag-explode-a-pie-chart-segment","tag-pie-chart-segments"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2157"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2157\/revisions"}],"predecessor-version":[{"id":6260,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2157\/revisions\/6260"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}