adding a data series to a chart with variable inputs.
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.
|