This issue should be solved in two steps. The first step is simply removing every other row of data from data in tab 1.
The second step is as follows.
I am trying to plot 3 time series on one excel graph. Two of these are x-y plots that follow the same date-time series and should be plotted as line graphs (with tick marks on Jan 1, Feb 1, Mar 1, etc). Y axis is water level, X axis is date-time. These data are in tab 1 (with every other row removed as per step 1).
The third time series are located in tab 2. Y axis is rainfall, X axis is date-time. These should be plotted as vertical bars that are in alignment with the date-time X axis as the two x-y plots from tab 1. However, and here's the catch, the rainfall data are collected and recorded as a different date-time series. (As you'll see in tab 2, there are very few rows of rainfall data and only one rainfall per day, and only for some days.)
All three plots need to be on the same graph and lined up according to the correct date. The two X-Y line plots should share a Y axis, and the rainfall should be a secondary Y axis.
Attached is the excel file. Thanks! water-levels-and-rainfall-for-ex.xls