Hi

I am using line chart to witch I have bind a custom table. Table format is as follows

MasterNo Col1 Col2 Col3 col4

P10              90     10

P20                       20     10    90

P30              10              50    80

 As row1 does not have value in last column chart is taking as 0. Also for P30 col2 does not have value it is also taken as 0

But what I want is to consider next value if no value is present in column

Is that possible?