Pie chart precentage

joeblack · Aug 12, 2017

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:

what I would like:

pict--2-sectors-pie-chart-management-indicators---vector-stencils-library.png--diagram-flowchart.png

AliGW · Aug 12, 2017

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	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 · Aug 12, 2017

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

joeblack · Aug 13, 2017

tnx to all

AliGW · Aug 13, 2017

You're welcome!

Pie chart precentage

joeblack

New member

AliGW

Administrator

Attachments

Bob Phillips

Super Moderator

joeblack

New member

AliGW

Administrator