Help please... Microsoft Excel charts

White95Max · 09-28-05, 08:39

I'm trying to create a chart in Excel. I need to compare the depth vs temperature data for 2 lakes on the same graph. I want to have Depth on the Y axis, and Temperature on the X axis.
The Depth always shows with 0 being at the bottom of the graph (at the origin). I want it to be at the top, as if you were looking directly through the lake water column, with the surface (zero) at the top.

How do I get the 0 to appear at the top?
How do I get depth and temperature to be plotted as one dot each time, rather than one dot for depth and one separate dot for temp?

Thanks for any help guys.

rfinkle2 · 09-28-05, 08:48

almost all of the controls for excel's charting capablilities are on the "format axis" tabs AFTER the chart is drawn. There is a min and max scale, and a categories in reverse order option that will probably get you what you want.

To access these, draw the chart...(not to insult your intelligence) by highlighting the data, choose the chart type you want.... and on the chart itself , select the axis you wish to change. Right click, and the formatting tabs should give you the oprtions you need to draw the chart the way you need it.

:

rfinkle2 · 09-28-05, 08:51

By the way, you can name the data on the charts before actually drawing the chart by labeling the columns with text. Do not leave a space, and the chart will automatically create a "key" for you with the axis labeled.

toyemp · 09-28-05, 06:23

1. Create the chart
2. right click on the axis you want to modify and select "format axis"
3. click on the "scale" tab
4. check the box "values in reverse order"
5. click "OK" to save your changes.

White95Max · 09-28-05, 06:33

Cool I got the axis reversed! Thanks!

the other pc · 09-29-05, 08:16

Quote:

Originally Posted by White95Max

...How do I get depth and temperature to be plotted as one dot each time, rather than one dot for depth and one separate dot for temp?...

If I understand this question you're currently seeing both temp and depth values on the Y axis and the X axis is the sample number for each pair?

If that's the case you're plotting them as two data sets on a line chart. You want to build the chart as an XY (scatter) chart to plot one verses the other instead.

PC.