How to auto Fix XAxis

I have two Series Date which have different number of row.Series 1 data and Serer 2 Data begin at Same pointofXAxis.
I want series 1 which is Tom's sales at each year begin at 2006 and Series 2 whirch is John's sales at each year begin at 2007.

DataSet ds = new DataSet();
ds.Tables.Add("Salary");

ds.Tables[0].Columns.Add("Dep");
ds.Tables[0].Columns.Add("Money");
ds.Tables[0].Columns.Add("Year");

ds.Tables[0].Rows.Add(new object[] { "Tom", 28000, 2006 });
ds.Tables[0].Rows.Add(new object[] { "Tom", 27500, 2007 });
ds.Tables[0].Rows.Add(new object[] { "Tom", 38500, 2008 });
ds.Tables[0].Rows.Add(new object[] { "Tom", 42300, 2009 });

ds.Tables[0].Rows.Add(new object[] { "John", 30000, 2007 });
ds.Tables[0].Rows.Add(new object[] { "John", 21000, 2008 });

Chart1.DataBindCrossTable(ds.Tables[0].DefaultView, "Dep", "Year", "Money", "");

How to auto Fix XAxis

You can use google to search for other answers

More Threads