Return a percentage of amount of values in column

**mcwee72** · 03-11-2010, 04:49 AM

Hi,

I have a column of data, I would like to create a bar chart which shows me the amount of values returned in %

For example:

15cm
0
29.55794521
0
0
27.34365217
0
0
0
0
25.57669565
0
0
0
0
0
0
0
0
0
0
0

I would like excel to count the amount of "0" in the column and then return as a % from all the values in the column.

I can create the charts, just would like to formula for the counting of values as a percentage.

Thanks

**DonkeyOte** · 03-11-2010, 05:10 AM

Assuming you mean to ignore A1 and values are always numeric:

=COUNTIF(A2:A22,0)/COUNT(A2:A22)

**mcwee72** · 03-11-2010, 05:20 AM

Originally Posted by DonkeyOte

Assuming you mean to ignore A1 and values are always numeric:

=COUNTIF(A2:A22,0)/COUNT(A2:A22)

Thanks

Sorry I have another question.

I'm trying to create a chart like this (attached excel file)

With the reading of 15cm.

Is this possible?

Thanks