set_categories {xlcharts}

set_categories

Description

Set the categories / x-axis values

Usage

set_categories(py_obj, labels)

Arguments

py_obj

py_obj

labels

labels

Value

An openpyxl Python object.

Examples

## Not run: 
wb <- Workbook()
ws <- active(wb)

chart1 <- BarChart(
  type = "col",
 style = 10,
  title = "Bar Chart",
  shape = 4
) |>
  y_axis(title = "Test number") |>
  x_axis(title = "Sample length (mm)")

data <- Reference(ws, min_col=2, min_row=1, max_row=7, max_col=3)
cats <- Reference(ws, min_col=1, min_row=2, max_row=7)

chart1 |>
  add_data(data = data, titles_from_data = TRUE) |>
  set_categories(cats)

## End(Not run)