PDA

View Full Version : Pie chart precentage



joeblack
2017-08-12, 02:20 PM
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:
7199

what I would like:
7200

AliGW
2017-08-12, 04:10 PM
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).

Bob Phillips
2017-08-12, 06:15 PM
You have two values to 'analyse', why would you bother charting them? Surely a simple percentage table would be far better.

joeblack
2017-08-13, 03:16 PM
tnx to all :)

AliGW
2017-08-13, 03:20 PM
You're welcome! :)