Format DateTime in radChartView with multiple Series in UI for WinForms

This is a migrated thread and some comments may be shown as answers.

Format DateTime in radChartView with multiple Series

2 Answers 18 Views

ChartView

This is a migrated thread and some comments may be shown as answers.

Sacha asked on 06 May 2019, 02:36 PM

formatted.png

original.png

Hi,

I have a Chart with dateTimes on the X Axis. I would like to print only the hour and minutes as it isn't readable otherwise (Original.PNG).
When I try to format it by using categoricalAxis on each series, it formats it correctly but creates an axis for each serie (Formatted.PNG).

I haven't found a way to keep only 1 Axis but with the formatted dateTimes.
I joined a copy of the important part of my code.

2 Answers, 1 is accepted

answered on 06 May 2019, 02:39 PM

Just realized the code couldn't be attached, here it is.

public FilesChart()

{

InitializeComponent();

var db = new Context();

var result = db.FILESPROCESSEDs.Select(m => m.TYPE).Distinct();

List<String> listResult = result.ToList();

foreach (string type in listResult)

{

var source = db.FILESPROCESSEDs.Where(m => m.TYPE == type);

BarSeries test = new BarSeries

{

DataSource = source.ToList(),

ValueMember = "AMOUNT",

CategoryMember = "DATETIME",

IsVisibleInLegend = true,

LegendTitle = type,

CombineMode = Telerik.Charting.ChartSeriesCombineMode.Stack

};

/*DateTimeCategoricalAxis categoricalAxis = new DateTimeCategoricalAxis();

categoricalAxis.DateTimeComponent = Telerik.Charting.DateTimeComponent.Hour;

categoricalAxis.PlotMode = Telerik.Charting.AxisPlotMode.BetweenTicks;

categoricalAxis.LabelFormat = "{0:HH:mm}";

test.HorizontalAxis = categoricalAxis;*/

radChartView1.Series.Add(test);

}

radChartView1.ShowLegend = true;

}

Accepted

answered on 07 May 2019, 10:16 AM

Hello Sacha,

You can create one axis and assign to all series:

public RadForm1()

{

InitializeComponent();

DateTimeCategoricalAxis categoricalAxis = new DateTimeCategoricalAxis();

categoricalAxis.DateTimeComponent = Telerik.Charting.DateTimeComponent.Hour;

categoricalAxis.PlotMode = Telerik.Charting.AxisPlotMode.BetweenTicks;

categoricalAxis.LabelFormat = "{0:HH:mm}";

for (int i = 0; i < 10; i++)

{

var source = GetTable();

BarSeries test = new BarSeries

{

DataSource = source,

ValueMember = "Value",

CategoryMember = "Time",

IsVisibleInLegend = true,

LegendTitle = "Item " + i,

CombineMode = Telerik.Charting.ChartSeriesCombineMode.Stack

};

test.HorizontalAxis = categoricalAxis;

radChartView1.Series.Add(test);

}

radChartView1.ShowLegend = true;

}

I hope this will be useful. Let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.