JZB
08-24-2009, 04:19 AM
Hi guys
I am creating a chart macro with variables around the series data.
There are two pieces of data, 2008 and 2009. the only variable that needs defining is the row number on each.
I have succesffully defined these (mydata and mydata 2)
The issue comes when inputting the variables into the syntax.
Series one is fine but series two syntax is a problem
ActiveChart.SeriesCollection(2).Values = "='[2008 PnL.xls]Income'!Rmydata2C4:Rmydata2C15"
The above variable incorporation is pretty schoolboy i know. :dunno
Any ideas would be appreciated
Thanks
Jon
I am creating a chart macro with variables around the series data.
There are two pieces of data, 2008 and 2009. the only variable that needs defining is the row number on each.
I have succesffully defined these (mydata and mydata 2)
The issue comes when inputting the variables into the syntax.
Series one is fine but series two syntax is a problem
ActiveChart.SeriesCollection(2).Values = "='[2008 PnL.xls]Income'!Rmydata2C4:Rmydata2C15"
The above variable incorporation is pretty schoolboy i know. :dunno
Any ideas would be appreciated
Thanks
Jon