[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.Drawing.IChartBars

IChartBars Interface

Represents the up bars in a chart group.

Up bars connect the points in the first series to higher values in the last series of a line chart group. Obtain this interface from UpBars after enabling up and down bars with HasUpDownBars.

Namespace: GrapeCity.Documents.Excel.Drawing
Assembly: DS.Documents.Excel.dll
Syntax
public interface IChartBars
Public Interface IChartBars
Examples
worksheet.Range["A1:D6"].Value = new object[,] {
    {null, "S1", "S2", "S3"},
    {"Item1", 10, 25, 25},
    {"Item2", -51, -36, 27},
    {"Item3", 52, -85, -30}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.Line, 200, 30, 300, 300);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], RowCol.Columns, true, true);
shape.Chart.LineGroups[0].HasUpDownBars = true;
IChartBars upBars = shape.Chart.LineGroups[0].UpBars;
upBars.Format.Fill.Color.RGB = Color.Green;

Properties

Name Description
Format

Gets the format of the chart bars.
Parent

Gets the parent IChartGroup that contains these chart bars.

Use this property to return to the chart group after accessing the up bars or down bars of a line chart.

Methods

Name Description
Delete()

Deletes this chart bars object.

Use this method on an IChartBars instance returned by UpBars or DownBars.