Hi
Not enough enough for me to spot a question and not enough info to
reproduce and fathom your error.
If you gave me the whole macro would you have to kill me....

regards
Paul

On Jan 28, 6:24*pm, Brian S wrote:
I recorded a macro to make a chart, and wanted to replace some of the series
with variables.

Here is the part that I get the error on:
"advanced homeland securityact" is the name of the tab the data is on and
chrt is a variable for the row.
* * ActiveChart.SeriesCollection(2).XValues = _
* * * * "='Advanced Homeland Securityact'!R1C9:R1C20"
* * ActiveChart.SeriesCollection(2).Values = _
* * * * "='Advanced Homeland Securityact'!" & Range(Cells(chrt, 9),
Cells(chrt, 20))
* * ActiveChart.SeriesCollection(2).Name = "=""actuals$"""

THanks.