I could use some help on a little statistical/quality project I am working on. I need to make multiple charts on a worksheet that referance data on another worksheet. I have everything layed out & I can make them one by one, but I was hopeing that there is an eaisier way. I will need around 100 total charts, & copying one & updating the data references for each data series will take me forever? Is there an eisier way to do this in VBA?
I am attaching an example of what I am looking to do. The raw data is on the worksheet called COMPRESS & the charts I made by hand are on Sheet1.
Another thing I need to do is have the charts data series adjust for the ammount of trials I have. Im my example I am useing 30 trials, but I will need the charts to adjust to show trial sizes of 5, 6, 10, 15, & 20. I was thinking of haveing a cell in COMPRESS that I can type in how many trials I have & then have VBA referance that number as a variable when making the charts, but I am not sure how to go about this.
Any help would be greatly appreciated.
Bookmarks