I am unable to set the Location of a ChartObject using Excel 2003,
VB 6.3.
The following code will return either Error 1004 or Run-time error '438':
Object doesn't support this property or method.
ActiveChart.Location Whe=xlLocationAsNewSheet, Name:="Test"
However ActiveChart seems to be valid because immediately before (or after
if the .Location line is commented out) other properties can be changed, e.g.:
ActiveChart.Axes(xlValue, xlSecondary).MaximumScale = 0.6