+ Reply to Thread
Results 1 to 11 of 11

Pie chart based on text?

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Question Pie chart based on text?

    Hi,

    I would like to create a pie chart based on text. For example, the process type is the title and this can either be incident, or service request.

    So if i select as data 2 times incident and 2 times service request, I would like to pie chart to show two equal pieces reflecting the 50%.

    Does anyone know how to make this based on text and not on numbers? Is that even possible?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Pie chart based on text?

    Could you attach a sample workbook showing your data layout?

    BSB

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Pie chart based on text?

    Schermafbeelding 2019-01-25 om 16.21.48.png
    This is all?

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Pie chart based on text?

    Use a pivot chart so that you can group and count the process category?
    Rory

  5. #5
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Pie chart based on text?

    It needs to be preformatted and as easy as possible so non expert users of excel can create them too

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Pie chart based on text?

    You can do that with a pivot table/chart - just use some code to refresh it automatically when the data changes, if it needs to be 'live' or have it auto-refresh on workbook open if not. Or, if you have a fixed list of categories, you can use some simple COUNTIF formulas in a separate table to create the chart.

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Pie chart based on text?

    You need to build a table from your data to drive the pie chart.

    In the attached the cells with red text are that table. A header and a simple COUNTIF formula to count the number of instances of each.

    As you add new values to the table on the left the chart will update.

    BSB
    Attached Files Attached Files

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

    Re: Pie chart based on text?

    Here's one option:

    C2 =IFERROR(INDEX(Table1[Process Category],MATCH(0,COUNTIF(C$1:C1,Table1[Process Category]),0)),"") Ctrl Shift Enter
    Drag the formula down to allow for as many unique categories as you might have.

    D2 =IF(C2="","",COUNTIF(Table1[Process Category],C2)/COUNTA(Table1[Process Category]))
    Drag the formula down the same amount as column C.

    Then put your Pie Chart in.

    See attachment. I allowed for 4 unique categories.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Pie chart based on text?

    Thanks for the options, will look if one of these will work, but afraid it is too difficult as the report needs to be rebuild every month. And the real thing is that I want to do it without counting, so wondering if this can be done from text.
    Last edited by WendyvdV; 01-25-2019 at 11:37 AM.

  10. #10
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Pie chart based on text?

    Quote Originally Posted by WendyvdV View Post
    And the real thing is that I want to do it without counting,
    See this is obviously impossible, right? How can you express what amount relative to total something is (a pie chart!) without counting them up??

    If you're worried it's too hard to do on a monthly basis, then the solution is to build it once, and then have a way to import a new list of data to feed into it. Rather than building a new chart each time, you just feed a different list of information into the chart, and regenerate it.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  11. #11
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Pie chart based on text?

    There are ways to count text too, without first adding a formula, unfortunately it seems not an option for a pie chart... let me think about an easy solution for the users, thanks for all the responses!

+ 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: 11
    Last Post: 03-22-2018, 03:54 AM
  2. Chart colour based on cell text
    By pauldaddyadams in forum Excel General
    Replies: 3
    Last Post: 03-02-2017, 05:39 PM
  3. Apply Color to chart based on Data source text color
    By ajm1991 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2016, 08:41 PM
  4. Replies: 8
    Last Post: 03-08-2015, 10:02 AM
  5. Macro to automatically change chart line style based on cell text
    By NUMagpie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2013, 04:30 PM
  6. [SOLVED] Custom chart title based on cell value and constant text value
    By welchs101 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2013, 09:32 AM
  7. Create a chart based on Text fields using Data Validation
    By mitchyfel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-04-2010, 09:01 AM

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