I am trying to set the x & y source data ranges for a SYScatter chart in VBA.
I use the following code to create the chart, but the x values are not used
for the x-axis (the automatic x-axis is 1,2,3...n).
ActiveChart.SetSourceData Source:=ActiveSheet.Range(Y_rngStr), _
PlotBy:=xlColumns
With ActiveSheet.ChartObjects(1).Chart
.ChartType = xlXYScatter
I have tried everything I can think of and variations of previous newsgroup
questions/answers without success. Any suggestions would be appreciated!