Gallery

Gallery > Analysis

Date Trend Line

Demonstrates adding a trendline to data with DateTime x values.

Download Show C# Code Show VB Code

<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>
<script runat="server">

void Page_Load(Object sender,EventArgs e)
{
// Demonstrates adding a trendline to data with DateTime x values.

Chart.TempDirectory = "temp";
Chart.Debug = true;

Chart.Type = ChartType.Combo;
Chart.Size = "600x350";
//Chart.Title = ".netCHARTING Sample";
Chart.XAxis.Minimum = new DateTime(DateTime.Now.Year, 1, 13);
Chart.XAxis.Maximum = new DateTime(DateTime.Now.Year, 1, 29);

// *DYNAMIC DATA NOTE*
// This sample uses random data to populate the chart. To populate
// a chart with database data see the following resources:
// - Help File > Getting Started > Data Tutorials
// - DataEngine Class in the help file
// - Sample: features/DataEngine.aspx

SeriesCollection mySC = getRandomData();

// Add the random data.
Chart.SeriesCollection.Add(mySC);
Series trend = mySC.Calculate("",Calculation.TrendLineLinearScatter,10);
trend.Type = SeriesType.Line;
Chart.SeriesCollection.Add(trend);

}

SeriesCollection getRandomData()
{
DateTime dt = new DateTime(DateTime.Now.Year, 1, 15);
Random myR = new Random(2);
SeriesCollection SC = new SeriesCollection();
for(int a = 1; a < 2; a++)
{
Series s = new Series("Series " + a.ToString());
for(int b = 1; b < 5; b++)
{
Element e = new Element("Element " + b.ToString());
e.YValue = myR.Next(50);
e.XDateTime = dt = dt.AddDays(2);
e.Name = "";
s.Elements.Add(e);
}
SC.Add(s);
}
return SC;
}

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>.netCHARTING Sample</title></head>
<body>
<div align="center">
<dotnet:Chart id="Chart" runat="server"/>
</div>
</body>
</html>

<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>
<script runat="server">

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates adding a trendline to data with DateTime x values.

Chart.TempDirectory = "temp"
Chart.Debug = True

Chart.Type = ChartType.Combo
Chart.Size = "600x350"
'Chart.Title = ".netCHARTING Sample";
Chart.XAxis.Minimum = New DateTime(DateTime.Now.Year, 1, 13)
Chart.XAxis.Maximum = New DateTime(DateTime.Now.Year, 1, 29)

' *DYNAMIC DATA NOTE*
' This sample uses random data to populate the chart. To populate
' a chart with database data see the following resources:
' - Help File > Getting Started > Data Tutorials
' - DataEngine Class in the help file
' - Sample: features/DataEngine.aspx

Dim mySC As SeriesCollection = getRandomData()

' Add the random data.
Chart.SeriesCollection.Add(mySC)
Dim trend As Series = mySC.Calculate("",Calculation.TrendLineLinearScatter,10)
trend.Type = SeriesType.Line
Chart.SeriesCollection.Add(trend)

End Sub

Function getRandomData() As SeriesCollection
Dim dt As DateTime = New DateTime(DateTime.Now.Year, 1, 15)
Dim myR As Random = New Random(2)
Dim SC As SeriesCollection = New SeriesCollection()
For a As Integer = 1 To 1
Dim s As Series = New Series("Series " & a.ToString())
For b As Integer = 1 To 4
Dim e As Element = New Element("Element " & b.ToString())
e.YValue = myR.Next(50)
dt = dt.AddDays(2)
e.XDateTime = dt
e.Name = ""
s.Elements.Add(e)
Next b
SC.Add(s)
Next a
Return SC
End Function

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>.netCHARTING Sample</title></head>
<body>
<div align="center">
<dotnet:Chart id="Chart" runat="server"/>
</div>
</body>
</html>

Sample FilenameDateTrendLine.aspx
Version4.2
Uses DatabaseNo

JS Charting

Gallery

Date Trend Line