r语言 - 在高包机堆叠列图中排序类别

Question

我在这里有一个Highcharter堆叠列图，我想根据数据集(Z, E, a)中的顺序对分组(类别)进行排序。但是Highcharter将这些片段按字母顺序排序(A, E, Z)。有没有办法把Z- A的片段排序?

非常感谢你的帮助。

install.packages("highcharter")
library(highcharter)
# data frame
city <- c("New York","New York","New York","Boston","Boston","Boston","Washington","Washington","Washington", "Seattle","Seattle","Seattle", "Houston", "Houston", "Houston") 
value <- c(1000,2500,2600,1900,1800,500,4900, 2000,3000,4000,5000,1500,1300,1400,1850)
category <- c("Z", "E", "A","Z", "E", "A","Z", "E", "A","Z", "E", "A","Z", "E", "A")
data <- data_frame(city, value, category)
#View(data)
# higcharter stacked column
hc <- data %>%
hchart('column', hcaes(x= city, y = value, group = category)) %>%
hc_plotOptions(series = list(stacking='normal'))%>%
hc_title(text='Stacked Chart',style = list(fontWeight = "", fontSize = "15px"))  
hc

Answer 1

默认情况下没有这样的选项，但我认为它可以使用Highcharts API中可用的自定义逻辑formatter函数创建:https://api.highcharts.com/highcharts/xAxis.labels.formatter

在这里你可以找到一篇展示如何在R中使用Highcharts JavaScript语法的文章:https://www.highcharts.com/blog/tutorials/working-with-highcharts-javascript-syntax-in-r/?fbclid=IwAR39-dztCuBUrncLQHEo9yNin00lRZfSqKY1JqAdvMU7KkokZGfTfj5DYB4