public void AddFormatRulesToBarSeries(ChartDashboardItem chart) { SimpleSeries series = chart.Panes[0].Series[0] as SimpleSeries; ChartItemFormatRule gradientRule = new ChartItemFormatRule(series.Value, series); FormatConditionRangeGradient condition = new FormatConditionRangeGradient(FormatConditionRangeGradientPredefinedType.RedBlue); gradientRule.Condition = condition; gradientRule.ShowInLegend = false; chart.FormatRules.Add(gradientRule); }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); PivotDashboardItem pivot = (PivotDashboardItem)dashboard.Items["pivotDashboardItem1"]; PivotItemFormatRule firstLevelRule = new PivotItemFormatRule(pivot.Values[0]); FormatConditionValue greaterThanCondition = new FormatConditionValue(); greaterThanCondition.Condition = DashboardFormatCondition.Greater; greaterThanCondition.Value1 = 30000; greaterThanCondition.StyleSettings = new AppearanceSettings(FormatConditionAppearanceType.Green); firstLevelRule.Condition = greaterThanCondition; firstLevelRule.IntersectionLevelMode = FormatConditionIntersectionLevelMode.FirstLevel; PivotItemFormatRule lastLevelRule = new PivotItemFormatRule(pivot.Values[0]); FormatConditionRangeGradient rangeCondition = new FormatConditionRangeGradient(FormatConditionRangeGradientPredefinedType.WhiteGreen); lastLevelRule.Condition = rangeCondition; lastLevelRule.IntersectionLevelMode = FormatConditionIntersectionLevelMode.LastLevel; PivotItemFormatRule grandTotalRule = new PivotItemFormatRule(pivot.Values[0]); FormatConditionRangeSet rangeTotalCondition = new FormatConditionRangeSet(FormatConditionRangeSetPredefinedType.ColorsPaleRedGreenBlue); grandTotalRule.Condition = rangeTotalCondition; grandTotalRule.IntersectionLevelMode = FormatConditionIntersectionLevelMode.SpecificLevel; grandTotalRule.Level.Row = pivot.Rows[0]; PivotItemFormatRule topCategoryRule = new PivotItemFormatRule(pivot.Values[0]); FormatConditionTopBottom topCondition = new FormatConditionTopBottom(); topCondition.TopBottom = DashboardFormatConditionTopBottomType.Top; topCondition.RankType = DashboardFormatConditionValueType.Number; topCondition.Rank = 3; topCondition.StyleSettings = new IconSettings(FormatConditionIconType.RatingFullGrayStar); topCategoryRule.Condition = topCondition; topCategoryRule.IntersectionLevelMode = FormatConditionIntersectionLevelMode.SpecificLevel; topCategoryRule.Level.Row = pivot.Rows[0]; topCategoryRule.DataItemApplyTo = pivot.Rows[0]; pivot.FormatRules.AddRange(firstLevelRule, lastLevelRule, grandTotalRule, topCategoryRule); dashboardViewer1.Dashboard = dashboard; }