what is wrong with this code??

[djpeter]

I am trying to make a dynamic chart, here is my code, And I do not want an a website reference, i want to know what is wrong with my code and how to fix it.

=SERIES('WCM MC'!$A$29:$B$29,'Monte Carlo '!rngdates,'Monte Carlo '!ssninety,6)

 

[RoryA]

OK - what I last posted should do that.

 

[djpeter]

so what would i put for the series formula, that corresponds to the horizontal axis data??

 

[RoryA]

The formulas from your last PM should work I think.

 

[djpeter]

yeah, i had it working and then when i closed the workbook and reopened it, i am now getting invalid reference errors. I will just have to work it out, the odd thing is the dates on the horizontal axis i want to expand, but do i have to enter that data separately? or does the rngdates in the series formulas for the graphed data take that into account already?

 

[RoryA]

rngDates should take it into account.