library(mschart)
library(officer)
library(xml2)
dat_no_group <- data.frame(
stringsAsFactors = FALSE,
cut = c("Fair", "Good", "Very Good", "Premium", "Ideal"),
carat = c(1, 0.82, 0.71, 0.86, 0.54),
n = c(1610L, 4906L, 12082L, 13791L, 21551L),
label = c("\U0001f603", "\U0001f525", "", "Hello \U0001f47d", "\U0001f44e"),
group = c("OK", "KO", "KO", "KO", "KO")
)
chrt <- ms_barchart(
data = dat_no_group, group = "group",
x = "cut", labels = "label", y = "n"
)
xml <- format(
chrt,
sheetname = "sheet1",
id_x = "64451212",
id_y = "64453248"
)
chart <- read_xml(xml)
showDataLabelsRange <- xml_find_all(chart, "//c:ser/c:dLbls/c:extLst/c:ext/c15:showDataLabelsRange")
# test that no showDataLabelsRange is set to 1
expect_equivalent(xml_attr(showDataLabelsRange, "val"), c("1", "1"))
label_pt <- xml_find_all(chart, "//c:ser/c:extLst/c:ext/c15:datalabelsRange/c15:dlblRangeCache/c:pt")
expect_equivalent(xml_text(label_pt),
c("", "\U0001f525", "\U0001f44e", "Hello \U0001f47d", "", "\U0001f603", "", "", "", ""))
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.