Hello Telerik Community:
I have the following issue, using the following code I get the results shown in the attached image.
Is there anyway to autostep or show only the dates that have some value on them?
Thanks in advance!
I have the following issue, using the following code I get the results shown in the attached image.
Is there anyway to autostep or show only the dates that have some value on them?
Thanks in advance!
//OADate column for chart:
DataColumn col =
new
DataColumn(
"OADate"
,
typeof
(System.Double));
dtable.Columns.Add(col);
//Converting SQL Datetime values to OADate column
int
b = 0;
foreach
(DataRow row
in
dtMerArrCru.Rows)
{
row[
"OADate"
] = Convert.ToDateTime(dtable.Rows[b][1]).ToOADate();
b++;
}
//Formatting chart:
RadChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortDate;
RadChart1.PlotArea.XAxis.Appearance.CustomFormat =
"MM/dd/yyyy"
;
RadChart1.PlotArea.XAxis.IsZeroBased =
false
;
RadChart1.PlotArea.XAxis.AutoScale =
false
;
RadChart1.PlotArea.XAxis.AddRange(Convert.ToDouble(dtMerArrCru.Rows[0][
"OADate"
]), Convert.ToDouble(dtMerArrCru.Rows[dtMerArrCru.Rows.Count - 1][
"OADate"
]), 1);
RadChart1.DataGroupColumn =
"Type"
;
RadChart1.DataManager.ValuesXColumn =
"OADate"
;
RadChart1.DataManager.ValuesYColumns =
new
string
[] {
"Quantity"
};
RadChart1.DataSource = dtable;
RadChart1.DataBind();