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

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
  • Comment on Re^2: Help using Win32::OLE to add Excel charts having multiple series

Replies are listed 'Best First'.
Re^3: Help using Win32::OLE to add Excel charts having multiple series
by marto (Cardinal) on Feb 23, 2010 at 10:54 UTC
Re^3: Help using Win32::OLE to add Excel charts having multiple series
by Anonymous Monk on Feb 23, 2010 at 06:48 UTC
    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"