help- Pivot chart

[adamlopez]

Pls help. I've been figuring out how to do this kind of chart.

I've attached my sample file. Hope you could help me.
Thanks!

[Andy Pope]

Try adding a field to the data which checks for Approved or not.

=IF(B4="approved",1,0)

The add new field to Value part of pivot table twice.
Set one value to Count the other to Sum