Difficulty charting complicated multiple-variable data.

Hi.

I've got a set of data I am having difficulty charting, and if anyone could offer their expertise I'd be most appreciative!

Basically I have data from a set of monitors which are recording pressure in a hydraulic system.

I have an upper and lower limit of allowable pressures.

What I would like to do is plot a chart from the data (it has been attached to try and help illustrate the difficulty I am experiencing) which shows the pressures on the y-axis and the times each day (08:00 and 17:00 concurrently) along the x-axis (so the x-axis would read 08:00 Day 1, 17:00 Day 1, 08:00 Day 2, 17:00 Day 2 and so on).

A separate chart can be produced for each hydraulic jack.

I would also like, if possible, to display the upper and lower limits of allowable pressures as a line parallel to the x-axis.

Oh and thanks in advance to any helpers!

Originally Posted by Andy Pope

Here is information on adding datum lines to charts
http://www.andypope.info/charts/averageline.htm

You will have to reformat your report data in order to get a better chart as currently you have blank lines and text within your data.

That's excellent Andy, thanks very much for your help.