multi-level x axis in plotly

Question

I didn't find any information if multiple level x axis are available for plotly. I guess it is possible to do it in ggplot2 (eg. this SO thread) and then transform it with ggplotly() but I would prefer a plotly solution. Is this possible? At the moment I am using an auxiliary column which concatenates year and month to the format "2017-12".

Example dataset:

data.frame(
        year = c(2017, 2018, 2018, 2017, 2018, 2018),
       month = c(12, 1, 2, 12, 1, 2),
       value = c(120, 110, 130, 90, 100, 110)
)

The result should look like this (year and month on the x axis):

I'm not too familiar with plotly, so I can't try an answer here; but, have you tried making a new variable with a line break in it?, e.g., dataframe$label <- paste(dataframe$month, "\n", dataframe$year) and using that for the label? — Nova
– Nova, Commented Aug 28, 2018 at 13:33
This stackoverflow.com/questions/51955803/… could help you. — MLavoie
– MLavoie, Commented Aug 28, 2018 at 16:39

Maximilian Peters · Accepted Answer · 2018-08-28 22:07:08Z

4

Since your x-axis values are just new line separated values you could paste the two columns and separate them with a HTML line break <br />. The labels are assigned to x-xaxis ticks.

library('plotly')

df <- data.frame(
  year = c(2017, 2018, 2018, 2017, 2018, 2018),
  month = c(12, 1, 2, 12, 1, 2),
  value = c(120, 110, 130, 90, 100, 110)
)

xaxis <- list('tickvals'= seq(1, length(df$year)),
              'ticktext' = paste(df$month, df$year, sep='<br />'),
              'tickmode' = 'array')

plot_ly(y=df$value, x=seq(1, length(df$year)), mode='lines', type='scatter') %>% layout(xaxis = xaxis)

answered Aug 28, 2018 at 22:07

Maximilian Peters

31.8k12 gold badges95 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Felix Grossmann Over a year ago

can you help there too? stackoverflow.com/questions/52443673/… - thank you for looking into it in advance :)

Collectives™ on Stack Overflow

multi-level x axis in plotly

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related