This should be a pretty straightforward solution for one who is skilled in Excel plotting, but I've written a few paragraphs to make the problem and goal very clear. Basically, I am trying to create a graph that shows 3 sets of data....details follow:
I have attached an excel spreadsheet with 3 tabbed worksheets, with each tab corresponding to data collected in a different town. Each tab contains: column A = date-time of hourly rainfall, column B = hourly rainfall, column C = blank, column D = date-time of hourly water level in shallow well, column E = hourly water level in shallow well, column F = blank, column G = date-time of hourly water level in deep well, column H = hourly water level in deep well.
Goal: To create one graph (showing all three data series described above) for each town's tabbed worksheet...three graphs in all, one per town. The graph will show all three sets of time series data discussed above. The rainfall data series (columns A and B) should be vertical bars on a secondary y axis. The shallow well water levels should be an x-y line plot (columns D and E). The deep well water levels should be an x-y line plot (columns G and H). Each graph should have tic marks at monthly intervals at Jan 1st, Feb 1st, Mar 1st, etc. and span the time that we have recorded rainfall data available.
One final note: There are a lot of rows of data. If "processing speed" becomes an issue, feel free to remove every Xth row of water level data (columns D and E and columns G and H) to end up with only 6 hourly values of water levels per day instead of 12 or 24. However, ALL rainfall rows (columns A and B) must remain for a total of 24 values per day, so please make sure rainfall rows are not removed.
Since only "partial solutions" have been provided for this question in the previous two tries, only a complete solution will be awarded points this time. Thank you for understanding, and thanks in advance!