I am trying to show outstanding amount for each customer in a bar graph using crystal report. X axis showing customer and Y showing the outstanding amount.

For that I have created a DataSet object with a table and 2 columns(X(sting) and Y(double)) in my project and the crystal report datasource is defined as this dataset.

In the form I am fetching the data from database in a datatable assigning it as the source for the chart as below

CRBarChart crRptChart = new CRBarChart();
crRptChart.SetDataSource(<dataTable>);
crvChart.ReportSource = crRptChart;

The chart is coming with X axis as the customer but the Y value for all the customers is displayed as 1.

I have checked the datatable have values for the outstanding column also. but why its not being displayed in the chart?

Can anyone help