Values for Graph
 

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.


--
maca
------------------------------------------------------------------------
maca's Profile: http://www.excelforum.com/member.php...o&userid=24892
View this thread: http://www.excelforum.com/showthread...hreadid=394543