Softcoding graph parameters
Posted on 2011-02-17
I have a large data set with several years of daily data which I would like to plot. The data is all in one column, but involves 15 different data sets one on top of another. I know the starting and ending rows for each data set and I can also get a legend for each. I would like to set up a graph so I could pick with data set to plot (using either a pulldown, or referencing the starting and ending row, and title information automatically. Can you explain how to set up the graph so it plots a time series graph for the data set I want so that I don't have to do each one manually? By manually I mean having to go into "source data" and change the parameters one at a time.