| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 58377 | 2005-05-30 02:03:00 | MS Excel X-axis ontop? | jamesyboi (6579) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 359677 | 2005-05-30 02:03:00 | Im doing my geo assignment, we measured the depth of waitakere ranges river in certain points. anyway i want to make a line graph in excel that has the x axis ontop instead of on the bottom. making the line look like the rivers depth at certain points.....eg ... look like a hole not a mountain is this possible? its not an option in Excel graph's -----------------------(x) | | | | | | (y) |
jamesyboi (6579) | ||
| 359678 | 2005-05-30 02:15:00 | Make the Y values negative | godfather (25) | ||
| 359679 | 2005-05-30 02:49:00 | yea but then the values appear with a - | jamesyboi (6579) | ||
| 359680 | 2005-05-30 03:21:00 | Yes, but isn't that correct? They are distances below the datum line, or negative to the datum line. |
godfather (25) | ||
| 359681 | 2005-05-30 04:39:00 | this isn't a normal graph, its a cross section of a river | jamesyboi (6579) | ||
| 359682 | 2005-05-30 05:12:00 | Right click on the Y axis Then click "format axis Then on scale Then change "category (X) axis crosses at..." to whatever you want. You might also like to change the max value of the Y scale if it doesn't suit. (Why isn't a cross-section of a river a normal graph?) |
rugila (214) | ||
| 359683 | 2005-05-30 05:52:00 | i duno im dumb. and that method doesn't work | jamesyboi (6579) | ||
| 359684 | 2005-05-30 06:49:00 | i duno im dumb. and that method doesn't work That puzzles me (both statements). It seems fine with my Excel (version 2002). If you can say in what sense or in what way it doesn't work then maybe I could offer more suggestions. Or perhaps just report what does happen when (if) you try it. |
rugila (214) | ||
| 359685 | 2005-05-30 07:17:00 | i tried that because a guy on mr excel forums told me to do it. it doesn't flip the line graph or the digits, just the little lines / placeholders for the values | jamesyboi (6579) | ||
| 359686 | 2005-05-30 07:27:00 | this isn't a normal graph, its a cross section of a rivergodfather is correct - you use negative values. Anything below your base level (which in your case would be the "surface" of the river) is a negative value. It has nothing to do with it being a graph or not - if you were drawing an actual cross-section of the river you would use the same method, as the river surface is your base level reference (or datum). Mike. |
Mike (15) | ||
| 1 2 | |||||