Hi,

I need to create one graph for each of the three tabs in the attached spreadsheet. (Each tab contains water level and rainfall data obtained at different sets of wells.)

Each graph will depict three sets of time series data. One set will be vertical bars on a secondary y axis (from columns A (date) and B (rainfall). The second will be an x-y line plot from columns D (date) and E (water levels at well a). The third set will be an x-y line plot from columns G (date) and H (water levels at well b). Each graph should have tic marks at Jan 1, Feb 1, Mar 1, etc.

Thanks!

TC

WL-vs-rain-for-expert-exchange.xls
I have added a tag to the rows of data for Rainfall (R) and Well 1D (1D) and Well 1S (1S).

I have then copied the 3 blocks of data including the tags into one block so you have date, data and tag as 3 column headers. This can then be sorted by date, giving one sorted block. Alongside this you can then create 3 additional columns of data pulling out the data from the data column into a column depending on tag. So you now have one table with 6 columns of data with Date, All Data, Tag, R Data, 1D Data, 1S Data.

This contiguous block of data can now be used for a graph, with 1D and 1S as line graphs on a secondary axis.

However, and this is the so far unresolved problem, because the data often goes to zero, the line does zigzags up and down to the x axis giving what looks like a block rather than a line.

Thanks

Rob H