or
//set the datasource chart1.DataSource = this.sqlDataSource1; //COMMENT OUT THIS SECTION AND THE CHART LOOKS GOOD //add new xaxis series items chart1.PlotArea.XAxis.AutoScale = false; chart1.PlotArea.XAxis.AddRange(1, 7, 1); chart1.PlotArea.XAxis[0].TextBlock.Text = "12/1/10"; chart1.PlotArea.XAxis[1].TextBlock.Text = "12/5/10"; chart1.PlotArea.XAxis[2].TextBlock.Text = "12/10/10"; chart1.PlotArea.XAxis[3].TextBlock.Text = "12/15/10"; chart1.PlotArea.XAxis[4].TextBlock.Text = "12/20/10"; chart1.PlotArea.XAxis[5].TextBlock.Text = "12/25/10"; chart1.PlotArea.XAxis[6].TextBlock.Text = "12/30/10"; //add the series 1 ChartSeries seriesAvg = new ChartSeries(); seriesAvg.DataYColumn = "Average"; seriesAvg.Type = ChartSeriesType.Area; seriesAvg.DefaultLabelValue = ""; chart1.Series.Add(seriesAvg); //add the series 2 ChartSeries seriesMax = new ChartSeries(); seriesMax.DataYColumn = "Max"; seriesMax.Type = ChartSeriesType.Line; seriesMax.DefaultLabelValue = ""; chart1.Series.Add(seriesMax);