R plotly chart based on multiple columns

The first problem is that month looks to be a string, so the months are in the wrong order. You should convert that column to the date format first.

As for the content of the plot, it appears to be mixing a scatter plot and line plot. You should check existing examples and adapt the code to get what you are after.

1 Like