I want to use RadChart to show the evolution of an indicator value compared to an objective value along a configurable period.
A database query returns the list of values, however maybe there is no values for all the periods.
01/01/2013 47,32
01/02/2013 35,36
01/03/2013 60,53
01/04/2013 82,75
I made the DataBind from a SqlDataReader.
On the other hand i know the objective value at the begining of the period and at the end of the period, for example:
01/01/2013 20 //This is the objective value in the first period
01/12/2013 120 //This is the objective value in the last period
In my chart I only can see the first 4 periods as the first serie only has 4 values.
Therefore I cannot see the value of the second serie at the end of the period.
Any suggestion.
Thank you in advance.
A database query returns the list of values, however maybe there is no values for all the periods.
01/01/2013 47,32
01/02/2013 35,36
01/03/2013 60,53
01/04/2013 82,75
I made the DataBind from a SqlDataReader.
On the other hand i know the objective value at the begining of the period and at the end of the period, for example:
01/01/2013 20 //This is the objective value in the first period
01/12/2013 120 //This is the objective value in the last period
ChartSeries serieObjective =
new
ChartSeries(
"Objective"
) { Type = ChartSeriesType.Line };
s
erieObjective.Items.Add(
new
ChartSeriesItem(1, 20));
int
periods = NumberOfPeriods(firstPeriod, lastPeriod); //Returns the number of periods (in this example 12)
serieObjective.Items.Add(
new
ChartSeriesItem(periods, 120));
chart.Series.Add(serieObjective);
In my chart I only can see the first 4 periods as the first serie only has 4 values.
Therefore I cannot see the value of the second serie at the end of the period.
Any suggestion.
Thank you in advance.