Hi all,
I am trying to populate multiple series within an xlLine chart from an array of doubles. The array is correctly populated so what I need is a way to reference an entire column within an array (Line 8 - SeriesCollection(x).Values)
Is this possible or should I create multiple (n x 1) arrays outside of the graph and then use those as inputs?
Please Login or Register to view this content.
Clarification: You say that you are trying to chart series from an array of doubles, but your code is treating IndexedReturns like a Range object (with a columns property). An array does not have properties and methods, and you access elements of an array using index numbers. I think the solution to your problem is going to be in exactly what is stored in indexedreturns and changing what it contains and how it is populated.
Originally Posted by shg
Yes I am trying to get around populating the graph using a column of an array by using methods I have used before on ranges. Basically what I want is an equivalent of the Matlab IndexedReturns(:,x) which refers to the entire column of the array.
Here is the code from the start, slightly modified to use only ranges. Still not working.
Please Login or Register to view this content.
"Still does not work" is not a very useful debugging statement. What error (or errors) are you getting and what statement(s) are associated with the error(s)?
I still am not sure of the details of what you want, but it feels very similar to what this user wanted: http://www.excelforum.com/excel-prog...ml#post4255097 Review that discussion and see if the concepts and solutions seem similar to what you want here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks