I am using Q2 2014 SP1 of Telerik Reporting. I am creating the entire Graph object in code (and setting it's datasource), and adding a couple of series to it (a line and a bar).
I need to be able to change the color of the individual bars in the bar series. I am graphing monthly measurements (metrics) where the Line Series is a "Planned" (like ar Budget) value and the Bar Series is the "Actual" value. This Actual value will either be above or below the Planned value and if they have hit or exceeded their plan for we want to color the bar Green for that single data point. If they've missed their plan, we want to color the bar Red.
This is very easy to do with your ASP.NET HTML Chart, but I don't see an example of how to do this with the reporting Graph. For now, I'm creating my BarSeries as below.
var actualColumnSeries1 = new Telerik.Reporting.BarSeries();
actualColumnSeries1.CategoryGroup = productCategoryGroup;
actualColumnSeries1.CoordinateSystem = cartesianCoordinateSystem1;
actualColumnSeries1.LegendItem.Value = "Actual";
actualColumnSeries1.SeriesGroup = orderDateGroup;
actualColumnSeries1.Y = "=CDbl(IsNull(Fields.ActualValue, 0))";
But it seems what I really want to do, is to do it like I do it with the ASP.NET HTML Chart. With the HTML Chart I:
Dim actualColumnSeries As New ColumnSeries
For Each bv As MyMetricValue in TheMetricValues
Dim seriesItem As CategorySeriesItem
seriesItem = New CategorySeriesItem(bv.ActualValueCalced)
seriesItem.BackgroundColor = GetDrawingColorFromValueStatus(bv.ActualValueStatusFromDB, False)
Is there a way to do this in the Reporting Graph? If not, then I'm in a bad spot because I can't use the ASP.NET HTML Charts due to their poor performance in older browser when there are a lot of them on my page (15 or more, and yes I've followed your article regarding performance optimization for the HTMLChart).