Chart fx 7 for webforms - Chart to be displayed with horizontal bar with date on x axis and number on y axis

[NDalal]

Hello,

 I have a requirement where i need to display a horizontal chart with date to be displayed on y axis and number on x axis. With the chart2.data.x[int, int] i am not able to display the chart as required as both the param's are needed as int.

Any help will be appreciated.

 Attached is the graph in excel as i need to display. Below is the code i have written but unable to map the datatable columns to the x axis and y axis of the chart.

 DataTable dttemp = new DataTable();<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

DataColumn dcCat = new DataColumn("Gates", Type.GetType("System.String"));

dttemp.Columns.Add(dcCat);

 

DataColumn dc = new DataColumn("Date", Type.GetType("System.DateTime"));

dttemp.Columns.Add(dc);

 

 

DataRow destRow = dttemp.NewRow();

destRow["Gates"] = "New";

destRow["Date"] = "1/30/2012";  

 

dttemp.Rows.Add(destRow);

 

destRow = dttemp.NewRow();

destRow["Gates"] = "0";

destRow["Date"] = "2/12/2012";

 

 dttemp.Rows.Add(destRow);

 

 destRow = dttemp.NewRow();

 destRow["Gates"] = "1";

 destRow["Date"] = "3/15/2012";  

 

 dttemp.Rows.Add(destRow);

 

 destRow = dttemp.NewRow();

 destRow["Gates"] = "2";

 destRow["Date"] = "4/30/2012";

 

 

 dttemp.Rows.Add(destRow);

 

 destRow = dttemp.NewRow();

 destRow["Gates"] = "3";

 destRow["Date"] = "5/15/2012";

 

 dttemp.Rows.Add(destRow);

 

 

 destRow = dttemp.NewRow();

 destRow["Gates"] = "4";

 destRow["Date"] = "6/10/2012";

 

 dttemp.Rows.Add(destRow);

 

 destRow = dttemp.NewRow();

 

destRow["Gates"] = "5";

 destRow["Date"] = "7/17/2012";  

 

 dttemp.Rows.Add(destRow);

 

 Chart2.Gallery = Gallery.Bar;

 

 Chart2.AllSeries.Horizontal = true;

 

 Chart2.DataSource = dttemp;

Thanks,

ND