GrapeCity.Documents.Excel.Drawing.IChartGroup.UpBars

UpBars Property

UpBars

Gets the up bars for a line chart group.

Up bars connect points where the last series in the chart group has a higher value than the first series. This property applies only to line charts.

Declaration

IChartBars UpBars { get; }

ReadOnly Property UpBars As IChartBars

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Month", "Planned", "Actual"},
    {"Jan", 10, 14},
    {"Feb", 18, 12},
    {"Mar", 15, 20}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.Line, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:C4"], RowCol.Columns, true, true);
IChartGroup chartGroup = chart.ChartGroups[0];
chartGroup.HasUpDownBars = true;
IChartBars upBars = chartGroup.UpBars;