property CategoryAxis.Categories as Variant
Specifies the category names

TypeDescription
Variant A variant expression that defines the category names as one of the following:
  • a string expression, that defines any of the following:
    • the list of values separated by comma/space, such as "Germany,France,Norway"
    • the column-name or column-index within the control's data, such as "x" or "0", so the values of the column defines the category names (the Data, Import or DataSource property defines the control's data)
  • a numeric expression, that defines any of the following:
    • the single category name, such as 1
    • the index of the column within the control's data, such as 1, so the values of the column defines the category names
  • a safe-array of values that indicates a single dimensional array, such as Array("Germany","France","Norway")
The Categories property defines the category names. The Categories property is equivalent with Categories parameter of the Add method. The format "categories(values)" separated by comma of serie's Data property can define categories as well, such as "Facebook(10 20 30),Google(15 15 40),Microsoft(20 20 50)".