How do I modify this formula (see below) so that the last ROW which contains a number (non-zero) is automatically plotted in the graph (which this =SERIES is derived from)?
=SERIES('Sheet1'!$D$2,'Sheet1'!$A$3:$A$62,'Sheet1'!$D$3:$D$62,1)
In this case, "62" is my last row which now contains a number. I want to replace "62" with some formula code so it is automatically found.
Last edited by ScubaGuy; 11-04-2013 at 01:06 PM.
If you are using vba then you need to dechiper the series formula, update the relevant pieces and then reapply new formula.
if you know the end row then you might be able to get away with
Please Login or Register to view this content.
I used this in a loop to accomplish my mission over the multitude of sheets. Problem is now, one of the graphs I am using it on has TWO series on it. This is only updating one of them. How do I modify the formula so that it updates both please?
Thanks,
Jim
loop through the series collection,
Please Login or Register to view this content.
Your Loop worked like a charm. THANK YOU. Now, is there any way to substitute the "62","63" with code that automatically finds the last row with a number in it and increases it row+1?
one way
Please Login or Register to view this content.
Yes, but how do I add that code into the chart's "=SERIES.." formula please, so the line chart automatically adjusts to add the next empty row?
Please Login or Register to view this content.
You da man! Thank you kindly!
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks