Hi RHeilman,
Thanks for your advice. I used your idea in a slightly different way and got it working successfully. I wrote the start and end rows in cells B1 and B2 respectively and then read those values and constructed the addresses in the macro. I had to use "JWalk Chart Tools" to...
In Excel, when creating a Macro to plot a chart, the follwoing code was recorded.
Sub PlotGraph2()
'
' PlotGraph2 Macro
' Macro recorded 13/05/2002 by Vasantha Jayasinghe
'
' Keyboard Shortcut: Ctrl+g
'
Sheets.Add
Range("B9").Select
Charts.Add
ActiveChart.ChartType =...