Looks to me like you're using a range containing Y values (the range is
names Y_rngStr) to populate the chart. You need to use a range containing
all your data in SetSourceData, or you need to populate the X and Y values,
SeriesCollection(i).XValues and .Values, of one series at a time, as
described he

http://peltiertech.com/Excel/ChartsH...kChartVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mitch" wrote in message
...
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!