Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |