Hi all.

I would love to improve how I make plots of my data. I have a spreadsheet (attached) wherein I enter data ("Data" worksheet). The last several columns of which, beginning with "CT to Rx Signing", I want to plot in several ways. You can see an example of some of the plots I want to make in the "Days From CT to Rx Signing" worksheet. This worksheet shows the output I want to make for the mentioned column in the "Data" worksheet, but the same is to be done for all the remaining columns to its right.

At the moment I have to manually filter the data in the "Data" tab and then copy and paste it into the appropriate location which I then, with the help of Excel formulas, I create histograms from and then plot (see colored cells in the "Days From CT to Rx Signing" worksheet).

I would like to be able to more fully automate the process such that I only have to enter new data into the "Data" worksheet and the remaining worksheets will automatically (or with the press of a button) update. Please advise.



Screenshot of "Data" worksheet:
http://i.imgur.com/dorhLiT.png


Screenshot of "Days from CT to Rx Signing" worksheet:
http://i.imgur.com/6f5DkJ4.png


The spreadsheet:
Planning Spreadsheet Test.xlsx