when referencing values in a chart you have to either input solid values or reference a range/array.
is there a method through vba that would allow me to use a formula?
another way to look at it is how can i output the results of a formula as an array?
I am trying to union the xvalue ranges of 2 graphs and use a vlookup to set the yvalues however both ranges can be of veriable sizes so i cannot fill in cells with vlookups.
Leon,
I have attached a file with the graph y=x^2. You can add as many additional data points as you want and the graph will automatically adjust.
You need to do 2 things:
1) create named ranges for x and y, they are of the form "=OFFSET(Sheet1!$A$2,0,0,COUNT(Sheet1!$A:$A),1)" so they will expand depending upon how many data points you have
2) use these named ranges in the graph.
Screenshots of 1 & 2 are included to help you. Any problems come back to me.
Regards
David
Last edited by JBeaucaire; 08-14-2013 at 10:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks