chart_ax_y: y axis settings

In mschart: Chart Generation for 'Microsoft Word' and 'Microsoft PowerPoint' Documents

y axis settings

Description

Define settings for a y axis.

Usage

chart_ax_y(
  x,
  orientation,
  crosses,
  cross_between,
  major_tick_mark,
  minor_tick_mark,
  tick_label_pos,
  display,
  num_fmt,
  rotation,
  limit_min,
  limit_max,
  position,
  second_axis = FALSE
)

Arguments

x	an ms_chart object.
orientation	axis orientation, one of 'maxMin', 'minMax'.
crosses	specifies how the axis crosses the perpendicular axis, one of 'autoZero', 'max', 'min'.
cross_between	specifies how the value axis crosses the category axis between categories, one of 'between', 'midCat'.
major_tick_mark, minor_tick_mark	tick marks position, one of 'cross', 'in', 'none', 'out'.
tick_label_pos	ticks labels position, one of 'high', 'low', 'nextTo', 'none'.
display	should the axis be displayed (a logical of length 1).
num_fmt	number formatting. See section for more details.
rotation	rotation angle. Value should be between -360 and 360.
limit_min	minimum value on the axis.
limit_max	maximum value on the axis.
position	position value that cross the other axis.
second_axis	unused

Illustrations

num_fmt

All % need to be doubled, 0%% mean "a number and percent symbol".

From my actual knowledge, depending on some chart type and options, the following values are not systematically used by office chart engine; i.e. when chart pre-compute percentages, it seems using 0%% will have no effect.

• General: default value

• 0: display the number with no decimal

• 0.00: display the number with two decimals

• 0%%: display as percentages

• 0.00%%: display as percentages with two digits

• #,##0

• #,##0.00

• 0.00E+00

• # ?/?

• # ??/??

• mm-dd-yy

• d-mmm-yy

• d-mmm

• mmm-yy

• h:mm AM/PM

• h:mm:ss AM/PM

• h:mm

• h:mm:ss

• m/d/yy h:mm

• #,##0 ;(#,##0)

• #,##0 ;[Red](#,##0)

• #,##0.00;(#,##0.00)

• #,##0.00;[Red](#,##0.00)

• mm:ss

• [h]:mm:ss

• mmss.0

• ##0.0E+0

• @

See Also

chart_ax_x(), ms_areachart(), ms_barchart(), ms_scatterchart(), ms_linechart()

Examples

library(officer)
library(mschart)

chart_01 <- ms_linechart(
  data = us_indus_prod,
  x = "date", y = "value",
  group = "type"
)
chart_01 <- chart_settings(chart_01, style = "marker")
chart_01 <- chart_ax_x(
  x = chart_01, num_fmt = "[$-fr-FR]mmm yyyy",
  limit_min = min(us_indus_prod$date),
  limit_max = as.Date("1992-01-01")
)
chart_01

mschart documentation built on Dec. 1, 2022, 1:32 a.m.