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)
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
I have a sheet which is as follows (only just a couple of rows pasted here)
Code:
[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