in reply to Help using Win32::OLE to add Excel charts having multiple series

That doesn't look like perl code, or code you have written.
  • Comment on Re: Help using Win32::OLE to add Excel charts having multiple series

Replies are listed 'Best First'.
Re^2: Help using Win32::OLE to add Excel charts having multiple series
by Anonymous Monk on Feb 23, 2010 at 06:40 UTC
    It is just a Visual basic pseudo code. Please help in writing Win32::OLE perl code to plot the excel chart, that takes the range of a column dynamically
      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).
        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"