+ Reply to Thread
Results 1 to 6 of 6

Pie Chart Problems

  1. #1
    Registered User
    Join Date
    09-02-2016
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    10

    Pie Chart Problems

    Good afternoon,

    I have just spend the good part of two hours trying to figure out how to make a pie chart out of certain values. So here's the problem:

    I have a spreadsheet where I want to see what words are in Column B, and then I need to figure out how often those words come up in Column B. So, I have a list that is something like this:
    LOT
    RSB
    LOT
    LOT
    RSB
    CTI
    CTI
    LOT
    RSB
    But there's a load of them, not just a few. And I need to see something like this:
    LOT = 4
    RSB = 3
    CTI = 2

    THEN I need to make a pie chart with that information.

    Can anyone help me?

  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: Pie Chart Problems

    Sounds like a pivot table & chart would be the quickest, easiest solution.

    See attachment for quick worked example.
    Attached Files Attached Files
    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
    Registered User
    Join Date
    09-02-2016
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    10

    Re: Pie Chart Problems

    That looks right! How did you make that?

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

    Re: Pie Chart Problems

    Click Insert > Pivot Table. In the 'Create Pivot Table' dialog, choose the source data range (in the example, this is Sheet1!A1:A10), and where you want to place the Pivot Table (existing worksheet, C1)

    Now you'll see an empty pivot table, and the Pivot Table Fields pane on the right hand side of the Excel window.

    Drag the 'WORD' field to the 'ROWS' section. Drag it again to the 'VALUES' section. There you go - your pivot table, with the distinct word values, and a count of their frequency.

    Now select the pivot table, and click Insert > Chart (of your choice - in this case, a 2D Pie Chart)


  5. #5
    Registered User
    Join Date
    09-02-2016
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    10

    Re: Pie Chart Problems

    You are a genius my friend, what a star! Thank you!!

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

    Re: Pie Chart Problems

    Happy to help Pivot tables are a BRILLIANT Excel feature, and well worth learning how to use them well.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. 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. Two problems with a pie chart
    By joh123 in forum Excel General
    Replies: 1
    Last Post: 12-02-2015, 04:58 AM
  2. problems with chart
    By redfur in forum Excel General
    Replies: 2
    Last Post: 04-26-2011, 04:36 PM
  3. Chart problems
    By steve_m_2003 in forum Excel General
    Replies: 1
    Last Post: 07-14-2010, 06:27 AM
  4. Chart for PV problems
    By decafdave in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-25-2008, 05:01 PM
  5. Chart problems
    By soulwind in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2007, 01:47 PM
  6. Chart Problems
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 02-27-2006, 10:10 PM
  7. Chart problems
    By Shel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2006, 05:10 PM

Tags for this Thread

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