Check the box in front of “Values in reverse order” and click OK
Now, you need to add the BATS data to your graph:
Select Design>Select Data
Under the “Legend Entries (Series)” box, click “Add”
In the “Series Name” box, type “BATS”
In the “Series X Values” box, select the icon with the red arrow, then go to your spreadsheet and click and drag to select cells C2-C59; click on the arrow icon again
Repeat this procedure for the “Series Y Values” box, selecting cells D2-D59; click OK
While you have the “Select Data Source” box open, you can change the name of your HOT data series :
Under the “Legend Entries (Series)” box, click on the “Pressure” series and click “Edit”
In the “Series Name” box, type “HOT” and click OK; click OK again
Your graph should now look something like this:
Now, you have to give the BATS data its own axis:
Click on the red BATS line, then right click to bring up the Data Series menu; select “Format data Series…”
Click the button in front of “Secondary Axis” and click “Close”
Use the procedure in step 3 to reverse the values on the Secondary Vertical Axis
Your graph should now look like this:
Finally, use the Chart Layout tools to add chart and axis titles.
Chart title: Nitrate vs. Depth
Value (X) Axis: Nitrate (µmol/kg)
Value (Y) Axis: Pressure (dbar)
Second value (Y) Axis: Depth (ft)
Your final graph should look something like this:
Use these same procedures to create a graph comparing HOT and BATS phosphate data.