sales1 Sales2 Sales3

  1/1/2006 5.34 2.2 4.44
  2/20/2006 2.38 3.22 5.33
  3/14/2006 9.22 7.88 2.39
  4/12/2006 3.21 5.22 3.48
  5/22/2006 4.44 8.22 6.12
  6/28/2006 3.22 4.22 2.44


  I was trying yo create line chart in crystal reports with above data. The dates should be in X axis and for each of the Sales column, I need one line graph. So in above eg. a line joining with all the values of Sales1. Similarly for Sales2 and Sales3. Also the rows and columns are dynamic. So I need to do it programatically using crystal reports or any such tool. Any help appricated.

gana

Oh I am able to do in design mode like this.
In chart expert data, on change of date column, mentioned sum of sales1, sum of sales 2 as show values. But how to do dynamically in coding!!!