VBA Code to automatically graph varying amounts of data
Posted on 2008-11-03
Im trying to develop VBA code to automatically graph a varying amount of data in excel,
I have a list of numbers, after a cell with the word "system" which needs to be graphed.
The cell with "system" occurs a number of times and each occurrence would be a different series on the same graph.
Hopefully that introduces the problem sufficiently!
So what I need the macro to do is search the excel sheet for the word "system" then select all the numerical data below that cell until it hits an empty cell and then work its way through the end of the sheet for all the remaining occurrences of "system",
All while graphing the series of numbers!