I did it. I selected the series and them added a sort based on the value I wanted to see. Thanks
Can you give some sample data as well, it will help to understand the problem better.
The poster was indicating he/she solved the problem. No further need for assistance.
Thanks Steve, yes took me fair bit of time to post the query and when i actually open the forum.
Good thing is that OP got to the solution of it.