GrapeCity.Documents.Excel.Drawing.IChartGroup.Overlap

Overlap Property

Overlap

Gets or sets how bars and columns are positioned in the chart group.

The returned value can be between -100 and 100. This property applies only to 2-D bar charts and 2-D column charts.

Declaration

int Overlap { get; set; }

Property Overlap As Integer

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Month", "Sales", "Target"},
    {"Jan", 10, 12},
    {"Feb", 14, 11},
    {"Mar", 16, 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:C4"], RowCol.Columns, true, true);
IChartGroup chartGroup = chart.ColumnGroups[0];
int overlap = chartGroup.Overlap;