Seven new chart types built on Office's chartEx family (Office
2016+): box-and-whisker (ms_boxplotchart()), funnel
(ms_funnelchart()), histogram (ms_histogramchart()), pareto
(ms_paretochart()), sunburst (ms_sunburstchart()), treemap
(ms_treemapchart()) and waterfall (ms_waterfallchart()).
Place a chart on an Excel sheet anchored to cells. Pass
anchor = "B2:H20" to sheet_add_drawing() to anchor between two
cells (Excel's default "move and size with cells"), or
anchor = "B2" to anchor to a single cell (move only). Omit
anchor for absolute placement. edit_as controls what Excel does
when rows or columns are resized.
num_fmt strings containing XML metacharacters (e.g. the
[>=1000] conditional Excel format) no longer break chart XML
generation; they are escaped automatically (#98).ms_stockchart() no longer fails when the x column is literally
named group (or x_val / y_val). Internal column names now use
a .mschart_ prefix to avoid collisions with user data.ms_chart_combine() supports independent x ranges via secondary_x
(top axis), in addition to the existing secondary_y mode.ms_chart_combine() no longer produces files PowerPoint refuses to
open, and reports clear errors on incompatible inputs (column
collisions, x mismatches, unsupported axis combinations).ms_piechart()), bubble
(ms_bubblechart()), radar (ms_radarchart()) and stock charts with
HLC and OHLC candlesticks (ms_stockchart()).ms_chart_combine().officer::sheet_add_drawing();
chart data is written into the sheet and linked automatically.chart_settings(grouping = ...)).chart_settings(table = TRUE)).major_unit, minor_unit,
major_time_unit and minor_time_unit (#105).legend_x, legend_y,
legend_w, legend_h in mschart_theme() / chart_theme() (#38).grid_major_line_x / _y or
grid_minor_line_x / _y to FALSE.chart_data_fill() updates the matching stroke colour by default,
so one call produces a filled shape with a matching border. Opt out
with update_stroke = FALSE.?mschart for the supported
matrix).chart_settings(table = TRUE) warns instead of being silently
ignored on chart types without a data table (scatter, radar, bubble,
pie).chart_labels() validates title, xlab and ylab: each must be
NULL or a single non-NA string.ms_scatterchart like on other chart types.chart_data_line_style("none") actually hides the line (#91, #99,
thanks Stefan Moog).date_fmt, double_fmt, ...) are applied to
axes again.chart_data_smooth() resolves the right series.chart_settings() no longer resets unrelated options when called
with partial parameters (linechart, areachart, scatterchart).?chart_data_size.chart_settings() on ms_bubblechart no longer accepts style —
it was silently ignored before. Remove the argument from your code.theme_ggplot2().labels is used.<>&.chart_labels_text() when only a fp_text was used as value for arg values.ph_with_chart and ph_with_chart_at as defunct.ph_with_chart and
ph_with_chart_at.chart_data_smooth() to activate line smoothchart_labels_text() to customise text labels%legend_text to theme functionms_linechart now accepts a non-numeric x axis.