+ Reply to Thread
Results 1 to 5 of 5

Pie Chart with two series

  1. #1
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Pie Chart with two series

    Okay, so I need to create a pie chart. The thing is, it needs two sets of data. My boss is fine with one set of data that looks kind of like a legend. I've attached a crude example.

    Is there any way to get this in the Pie chart itself?
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Pie Chart with two series

    Right-click on the pie chart, go to Format Data Labels, check the "Value From Cells" box and highlight C2:C4, then separate it with (New Line).

    See attachment.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Re: Pie Chart with two series

    That works! Thanks!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Pie Chart with two series

    You're welcome. Happy to help.

    Thanks for the rep!

  5. #5
    Registered User
    Join Date
    10-11-2019
    Location
    San Jose, CA
    MS-Off Ver
    2016
    Posts
    2

    Re: Pie Chart with two series

    So many great solutions on this forum! thanks

+ 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-19-2017, 07:52 PM
  2. Delete Pivto Chart Series when certain word/text is found in the Series Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2016, 03:19 PM
  3. Apply format of a series to a similar series in a different chart
    By Skiffie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2013, 10:43 PM
  4. Chart front-to-back series display if series are different chart types
    By Exconomist in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2012, 06:49 AM
  5. Series function disappears from Chart series edit
    By lloydsp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 07:45 PM
  6. mixing column chart types for series and macro series?
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2010, 05:27 PM
  7. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 PM

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