GrapeCity.Documents.Excel.Drawing.IAxis.ReversePlotOrder

ReversePlotOrder Property

ReversePlotOrder

Gets or sets whether Excel plots data points on the axis from last to first.

This property is true when the axis uses reverse plot order.

Declaration

bool ReversePlotOrder { get; set; }

Property ReversePlotOrder As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 120},
    {"Feb", 150},
    {"Mar", 90}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
IAxis axis = shape.Chart.Axes.Item(AxisType.Category);
axis.ReversePlotOrder = true;
bool reversePlotOrder = axis.ReversePlotOrder;