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 =...