I am trying to plot multiple series on the same plot using the setsourcedata method. The tricky part is that with this spreadsheet, the number of series is variable. In other words, one day there might be two series that I need to plot, and the next day there might be five, so the exact locations of the series at which data must be pulled from changes depending on the number of series that must be plotted. Right now I am using the integer h to iterate the series, however it only plots the last series in the group. Can this be done with the setsourcedata method? Is there another way to accomplish what I am trying to do? Here is my code so far:
Bookmarks