GrapeCity.Documents.Excel.Drawing.IAxis.CategoryNames

CategoryNames Property

CategoryNames

Gets or sets all the category names for the specified axis as a text array.

Returns the category labels currently used by the axis.

Declaration

string[] CategoryNames { get; set; }

Property CategoryNames As String()

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Q1", 120},
    {"Q2", 150},
    {"Q3", 180}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
IAxis axis = chart.Axes.Item(AxisType.Category, AxisGroup.Primary);
string[] categoryNames = axis.CategoryNames;