Hi,

I have a graph fo representing rolling returns. It works very well for monthly and quarterly data, but when using weekly or daily data, it gives me a "macro error".
I checked the data , and there is no missing value, the names are correct, the security settings are proper, and the whole calculations are done in the same file, so no write error possible.

The code where it stops when debuging:

chRollRet.SeriesCollection(1).Values = Sheets("InputHelp").Range("M" & dt + 2 & ":M" & lr)

,where "chRollRet" is the Graph, "dt" is a integer variable giving the first row, and "lr" is the integer giving the last row.

Can anyone help me, pls???

Cheers,
Maca.