Automating array selection and graph
Posted on 2011-05-06
I want to create a spreadsheet that automatically build an array of data (based on user selections) taken from a larger array of data, and then create a graph of the selected array data. I have attached a spreadsheet as an example. On the Dataset tab are a series of datasets with monthly data. On the Select tab in cells D4 through D8 are the datasets selected for inclusion . Cells G4 and G6 show the start and end months selected. After a macro "Run" button is pushed, the data below the selection criteria should be automatically created. That's step 1. Step 2 would be to have a graph of the data automatically be generated.
I hope this is doable for the points...