<asp:chart id="Chart1" runat="server" Height="365px"
      Width="700px" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)" ImageType="Png"
      BackColor="WhiteSmoke" BackSecondaryColor="White" BackGradientStyle="TopBottom"
      palette="BrightPastel" BorderWidth="2"
      BorderColor="26, 59, 105">
          <titles>
              <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 14.25pt, style=Bold" ShadowOffset="3" Text="Chart Title" Alignment="MiddleLeft" ForeColor="26, 59, 105"></asp:Title>
          </titles>
      <legends>
          <asp:Legend Enabled="True" IsTextAutoFit="False" Name="Default" BackColor="Transparent" Font="Trebuchet MS, 8.25pt, style=Bold"></asp:Legend>
          </legends>
      <borderskin skinstyle="Emboss"></borderskin>
          <chartareas>
              <asp:ChartArea Name="ChartArea1" BorderColor="64,                                64, 64, 64" BorderDashStyle="Solid" BackSecondaryColor="White" BackColor="Gainsboro" ShadowColor="Transparent" BackGradientStyle="TopBottom">
               <axisy2 enabled="False"></axisy2>
               <axisx2 enabled="False"></axisx2>
                   <area3dstyle Rotation="10" perspective="10"   Inclination="15" IsRightAngleAxes="False" wallwidth="0" IsClustered="False"></area3dstyle>
                   <axisy linecolor="64, 64, 64, 64" IsLabelAutoFit="False" ArrowStyle="Triangle">
                   <labelstyle font="Trebuchet MS, 8.25pt, style=Bold" />
           <majorgrid linecolor="64, 64, 64, 64" />
           </axisy>
           <axisx linecolor="64, 64, 64, 64" IsLabelAutoFit="False" ArrowStyle="Triangle">
                   <labelstyle font="Trebuchet MS, 8.25pt, style=Bold" IsStaggered="False"/>
               <majorgrid linecolor="64, 64, 64, 64" />
        </axisx>
            </asp:ChartArea>
        </chartareas>
    </asp:chart>

foreach (TreeNode node in ChartTreeView.CheckedNodes)
{
    if(node.Text.Contains("XXX") )
    {
        Series series = Chart1.Series.Add(node.Text);
        series.ChartArea = "ChartArea1";
        series.ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), charts[1], true);
        SqlConnection sqlConnection = new SqlConnection(@"DATA GOES HERE FOR SQL");
        sqlConnection.Open();

            SqlCommand nodeQuery = new SqlCommand();
            nodeQuery.CommandText = "";
            if (node.Text.Contains("XXX"))
            {
                nodeQuery.CommandText = "SELECT (Date + CONVERT(datetime,Time)) As TimeStamp, (MW + kW) As Energy, [EquipmentID] FROM EquipmentData WHERE [EquipmentID] = '" + node.Text + "' AND (Date + CONVERT(datetime,Time)) BETWEEN '" + startDateFilter + "' AND '" + endDateFilter + "' and [SiteID] = "+ProjectNavigation.SelectedValue.ToString()+" ORDER BY TimeStamp";";
                nodeQuery.Connection = sqlConnection;

            }
            if (nodeQuery.CommandText != "")
            {
                SqlDataReader reader = nodeQuery.ExecuteReader();
                while (reader.Read())
                {
                    double value = (double)reader["Energy"];
                    DateTime TimeStamp = (DateTime)reader["TimeStamp"];
                    string equipID = (string)reader["EquipmentID"];

                    series.Points.AddXY(TimeStamp, value);

                }
                sqlConnection.Close();
            }
        }
    }
    Chart1.DataBind();

public void SetAxisInterval(System.Web.UI.DataVisualization.Charting.Axis axis, double interval, DateTimeIntervalType intervalType)
    {
        SetAxisInterval(axis, interval, intervalType, 0, DateTimeIntervalType.Auto);
    }

    public void SetAxisInterval(System.Web.UI.DataVisualization.Charting.Axis axis, double interval, DateTimeIntervalType intervalType, double intervalOffset, DateTimeIntervalType intervalOffsetType)
    {
        // Set interval-related properties
        axis.Interval = interval;
        axis.IntervalType = intervalType;
        axis.IntervalOffset = intervalOffset;
        axis.IntervalOffsetType = intervalOffsetType;

    }

SetAxisInterval(Chart1.ChartAreas["ChartArea1"].AxisX, 10, DateTimeIntervalType.Minutes);

DateTime startDateVal;
DateTime endDateVal;

TimeSpan span = DateTime.Parse(endDate.Text) - DateTime.Parse(startDate.Text);
if (span.TotalDays > 0)
{
    startDateVal = DateTime.Parse(startDate.Text);
    endDateVal = DateTime.Parse(endDate.Text;
}
else
{
    startDateVal = DateTime.Parse(startDate.Text);
    endDateVal = DateTime.Parse(endDate.Text).AddDays(1);
}

Chart1.ChartAreas["ChartArea1"].AxisX.Minimum = startDateVal.ToOADate();
Char1t.ChartAreas["ChartArea1"].AxisX.Maximum = endDateVal.ToOADate();