This can be done by two ways...
1. Having a group identifier and writing a formula for those four groups separately. so that u can use the formulas to create four charts.
2. Otherwise if the number of ppl are less then it can be hardcoded. Will involve lot of manual effort.
I would suggest the first point.
Edited by sunij - 18 Sep 2007 at 2:06am