Crystal Report Line graph queries.

Hi, i am trying to plot a line graph in crystal report but i am not sure which value should i put in the chart expert. I.e On Change of record, value -> show value.

In my database i have the following columns.

Date,Weight

I would like to plot a graph with the Y axis the weight range, the X axis will be the count of weight.

VB Code:

e.g
 
4kg          x
3kg
2kg
1kg
       1 2 3 4
         Count

So i know there are 4 counts of 4kg in the database. By the way, if the range of count is wide.how do i make limit it to like 10 counts per page. so if there are 40 counts , it will be 4 pages.

thanks experts!

Ok , u put the value which u want to show on X axis in X axis and same for Y axis , and the value for which u want to plot the graph , put that value inside the section "On change of".