Formatting axis in Surface plot Plotly R

Question

Making a 3 month curve for natural gas prices. I'm having some axis issues. I'd like to be able to have the dates show up instead of number of days.

library(ggplot2)
library(Quandl)
library(magrittr)
require(plotly)

#Get first 3 month on the nat gas curve data from Quandl
my_start_date <- "2013-01-05"

gas1<-Quandl("CHRIS/CME_NG1", start_date = my_start_date, type = "xts")
gas2<-Quandl("CHRIS/CME_NG2", start_date = my_start_date, type = "xts")
gas3<-Quandl("CHRIS/CME_NG3", start_date = my_start_date, type = "xts")

#isolate the last prices
gas1a<-gas1[,"Last"]
gas2a<-gas2[,"Last"]
gas3a<-gas3[,"Last"]

p <- merge(as.zoo(gas1a), as.zoo(gas2a), as.zoo(gas3a), all = FALSE)

#3d graph
plot_ly(z = p, type = "surface")%>%
  layout(title = "3 month Nat Gas curve",
         scene = list(
            xaxis = list(title = "Month"),
            yaxis = list(title = "Days"),
            zaxis = list(title = "Price")))

MLavoie · Accepted Answer · 2016-06-13 18:19:51Z

1

Are you looking for this?

plot_ly(y=index(p), z = p, type = "surface")%>%
  layout(title = "3 month Nat Gas curve",
         scene = list(
            xaxis = list(title = "Month"),
            yaxis = list(title = "Days", tickangle = 180),
            zaxis = list(title = "Price")))

edited Jun 13, 2016 at 18:19

answered Jun 13, 2016 at 18:08

MLavoie

9,91641 gold badges42 silver badges58 bronze badges

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

3 Comments

Rhodo Over a year ago

thats great- how do I angle the text of the dates?

Rhodo Over a year ago

Great thank you- any idea how I reverse axis labels on x axis? Final one sorry

MLavoie Over a year ago

we usually add autorange = "reversed" , but it looks like it's not working for 3D plot

Collectives™ on Stack Overflow

Formatting axis in Surface plot Plotly R

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related