in reply to Re^2: Help using Win32::OLE to add Excel charts having multiple series
in thread Help using Win32::OLE to add Excel charts having multiple series

Um, no. Please ask a clear and coherent actual question, then you can get help in writing, as opposed to someone just writing something for you (and guessing and guessing).
  • Comment on Re^3: Help using Win32::OLE to add Excel charts having multiple series

Replies are listed 'Best First'.
Re^4: Help using Win32::OLE to add Excel charts having multiple series
by Anonymous Monk on Feb 24, 2010 at 13:40 UTC
    How to translate following VBA code to perl code Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!R2C1:R801C1" ActiveChart.SeriesCollection(1).Values = "='Sheet1'!R2C2:R801C2"