writexl (version 2.0.0)

xl_chart_table: The table of values under a chart

Description

`xl_chart_table()` prints the plotted numbers in a grid beneath the chart, which is Excel's "Data Table" chart element. It is given to [xl_chart()] as `data_table`.

Naming none of the grid options leaves Excel's own: horizontal, vertical and outline borders drawn, and no legend keys.

Usage

xl_chart_table(
  show_keys = NA,
  horizontal_border = NA,
  vertical_border = NA,
  outline_border = NA,
  format = NULL
)

Value

An `xl_chart_table` object.

Arguments

show_keys

Print each series' legend swatch in the table.

horizontal_border, vertical_border, outline_border

Which of the grid's borders to draw.

format

An [xl_format()] styling the table's text --- the [xl_font()] group only.

See Also

[xl_chart]

Other images and charts: xl_chart(), xl_chart_axis(), xl_chart_error_bars(), xl_chart_labels(), xl_chart_legend(), xl_chart_marker(), xl_chart_series(), xl_chart_trendline(), xl_chartsheet(), xl_image()

Examples

xl_chart_table()
xl_chart_table(show_keys = TRUE, vertical_border = FALSE)