我有一个像下面这样的数据集
City<-c("X","Y","Z","X","Z","X","Y")
House_Unit_Id<-c("H1","H2","H3","H4","H5","H6","H7")
Adult<-c(50,100,60,40,50,80,60)
Child<-c(40,0,40,20,50,20,30)
Baby<-c(10,0,0,40,0,0,10)
data<-data.frame(City,House_Unit_Id,Adult,Child,Baby)
City House_Unit_Id Adult Child Baby
X H1 50 40 10
Y H2 100 0 0
Z H3 60 40 0
X H4 40 20 40
Z H5 50 50 0
X H6 80 20 0
Y H7 60 30 10
我需要一个像下面这样的百分比堆叠柱状图
![What I need](https://istack.dev59.com/fKAcP.webp)
Chart <- plot_ly(data,x = ~City, y = ~Adult, type = 'bar',name= 'Adult') %>%
add_trace(y = ~Child, name = 'Child') %>%
add_trace(y = ~Baby, name = 'Baby') %>%
layout(yaxis = list(title = 'Percentage (%)'),barmode = "stack")
我在R的plotly包中找不到任何关于这种类型图表的答案。请问有人可以帮助我吗?