Charting Data which is under/over a certain Value!

[AdamWWD]

I am hoping that someone can point me in the right direction here.

I have a sheet which is as follows (only just a couple of rows pasted here)

[TABLE="width: 406"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]DateOfArrival
[/TD]
[TD]   Country
[/TD]
[TD]Fruit[/TD]
[TD]SmallestBerry[/TD]
[/TR]
[TR]
[TD="align: right"]04/09/2014
[/TD]
[TD]   Poland
[/TD]
[TD]Blueberries[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]03/09/2014[/TD]
[TD]   Mexico
[/TD]
[TD]Blueberries[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]03/09/2014[/TD]
[TD]   Poland
[/TD]
[TD]Blueberries[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]03/09/2014   
[/TD]
[TD]Poland
[/TD]
[TD]Blueberries[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]

What I Need to do is Chart the amount of times that 'Smallestberry' is under 14, but I also need to show the data by country and Histograms arent working for with this.

If someone would be so kind and help it would be appreciated.

Thanks

 

[mrmmickle1]

Try a Setup like this:

Excel 2012
	A	B	C	D	E	F	G
1	DateOfArrival	Country	Fruit	SmallestBerry		Unique Country	Count
2	4/9/2014	Poland	Blueberries	0		Poland	3
3	3/9/2014	Mexico	Blueberries	13		Mexico	1
4	3/9/2014	Poland	Blueberries	8
5	3/9/2014	Poland	Blueberries	8
Data Review Check

Cell Formulas
Range	Formula
G2	=COUNTIFS($B$2:$B$5,F2,$D$2:$D$5,"<14")
G3	=COUNTIFS($B$2:$B$5,F3,$D$2:$D$5,"<14")

Or look at filtering your data by Criteria (<14) and simply using a PivotChart. CLICK HERE FOR MORE INFO ON PIVOT CHART