Grouping data for charting
Hello Guys,
I have a dataset which looks something like this:
Delivery Date | Courier
01/01/2011 DHL
01/01/2011 DHL
01/01/2011 DPD
01/01/2011 FEDEX
.....
I want to draw a pie chart, which gives me a percentage of deliveries carried out by each courier. The problem is that the pie chart only allows for something like 25 datapoints - in a world where we have more than 25 couriers this becomes a problem :-)
What I want to achieve is a chart that shows the break down for perhaps the 10 most popular couriers, and then groups all other courier into an 'Insignificant Others' group, which is the final slice of the pie.
Can anone offer any guidance on this? Please bare in mind I'm new to ZOHO.
Thanks,
Robert