Displaying 1 result from an estimated 1 matches for "newseri".
Did you mean:
newser
2009 Jun 27
1
Creating Excel-Charts via RDCOMClient
...le"]] <- TRUE
r <- sh$Range("A1:D1")
r[["Value"]] <- c(1:4)
ch <- ex$Charts()
ch$Add()
ac <- ex$ActiveChart()
ac[["ChartType"]] <- xlXYScatterSmoothNoMarkers
ac$Location(Where=xlLocationAsObject, Name="Tabelle1")
ac$SeriesCollection()$NewSeries()
ac$SeriesCollection(1)[["XValues"]] <- r
ac$SeriesCollection(1)[["Values"]] <- r
#-------------------------------------------------------------------
But I don't perfer this way writing calculated values like "c(1:4)" to the
Excel Sheet and calling them...