Results 1 to 5 of 5

Thread: Pie chart precentage

  1. #1

    Question Pie chart precentage



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I'm trying to create a pie chart that would show me the precentage of my two values in a single collum. But I can't seem to get it right.

    What I have:
    Click image for larger version. 

Name:	Untitled.jpg 
Views:	11 
Size:	93.1 KB 
ID:	7199

    what I would like:
    Click image for larger version. 

Name:	pict--2-sectors-pie-chart-management-indicators---vector-stencils-library.png--diagram-flowchart.png 
Views:	8 
Size:	16.1 KB 
ID:	7200

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    726
    Articles
    0
    You need to summarise your data (you can position the chart over the summary cells if you wish to hide them):

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    1
    win win
    6
    2
    lose lose
    4
    3
    win
    4
    lose
    5
    win
    6
    win
    7
    win
    8
    lose
    9
    lose
    10
    win
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    D
    1
    =COUNTIF($A$1:$A$10,C1)
    2
    =COUNTIF($A$1:$A$10,C2)
    Sheet: Sheet1

    Then you will get the attached (data labels changed to percentages).
    Attached Files Attached Files
    Last edited by AliGW; 2017-08-12 at 03:12 PM.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    You have two values to 'analyse', why would you bother charting them? Surely a simple percentage table would be far better.

  4. #4
    tnx to all

  5. #5
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    726
    Articles
    0
    You're welcome!
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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