ok, I tried making a range that does not include blank cells and I do not get
the error. I will need to find a way to make a subset of the named ranges
that does not include blanks then plot it using the advice you all have given
me.

Let me work on it for a while..
thanks,
Matt

"Matt S" wrote:

All,

Thanks so much for your suggestions. I still am receiving an error:
Run-time error '1004' Unable to set the XValues property of the Series class

Part of my range are empty cells... could this be the reason why?

Thanks,
Matt

"Jon Peltier" wrote:

Use the name of the sheet that holds the name, and use syntax like this:

ActiveChart.SeriesCollection(1).XValues = "='" & ActiveSheet.Name &
"'!TheRange"

Excel will fill in the appropriate local or global scope for the name

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


"Peter T" <peter_t@discussions wrote in message
...
Your error description suggests you are running the code without actually
selecting a chart, or maybe you've just created a chart that doesn't yet
have a series. Beyond that the the syntax is not quite right

s = "='" & ActiveWorkbook.Name & "'!" & "Beginning_Timer"
s = "=Beginning_Timer"
ActiveChart.SeriesCollection(1).XValues = s

Obviously ensure a chart is active. Presumably the defined name is in the
same workbook, otherwise change ActiveWorkbook.Name to "myBook.xls" But if
working with a worksheet (local) name change use sheet-name.

Regards,
Peter T






"Matt S" wrote in message
...
I have a few ranges that are named within Excel. I'd like to chart my
Beginning_Timer range against my Temp_Ramp range with a XY Scatter plot.

If I put ActiveChart.SeriesCollection(1).XValues = "=Beginning_Timer"
it gives me an error '91' Object variable or With Block variable not set.

Help?
<3 Matt