+ Reply to Thread
Results 1 to 3 of 3

How to enhance an individual segment in a pie chart

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    44

    How to enhance an individual segment in a pie chart

    I'm looking to create a pie chart which has a segment of the chart much bigger than the rest, and separated from the chart.

    Example, the total value of something is 100,000; split between a cell value of 75,000 and another of 25,000.

    I want the pie chart to go 75% of the way around like a regular pie chart, and then have the 25% separated, but much larger in scale than the rest of the pie chart. You should still see that it is part of the same story, but that it is sticks out to the viewer.

    Is this possible in Excel?

    Many thanks.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to enhance an individual segment in a pie chart

    You could do it with two overlaid pie charts - the bottom one only displays the 75% data point, the top one only the 25% data point. Set background of top chart to no fill, scale and position to suit.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to enhance an individual segment in a pie chart

    You can do it in one chart but I don't know why you would want to. Comparison of pie slices is difficult enough without changing the scaling.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  2. Help creating a segment chart with growth
    By 198four in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-12-2013, 05:18 PM
  3. 2 individual bar graphs on same chart
    By jessmoose in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-05-2013, 08:20 PM
  4. Chart Individual Days
    By Boo123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-15-2013, 02:55 PM
  5. Setting a pie chart segment to No Fill
    By Lynxbci3 in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1