| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 102325 | 2009-08-15 10:23:00 | Excel graph woes - can't get the axis line to the left | Renmoo (66) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 801356 | 2009-08-15 10:23:00 | Attached file: totallywtf.png (www.imagef1.net.nz) (12 KB) The y-axis line is somehow plotted on the right. Can anyone suggest some method to make it appear on the left instead? The y-axis values were previously on the right side too, but I shifted it to the left by telling Excel to position it on the "low" side. Grr......... :mad: Thanks! |
Renmoo (66) | ||
| 801357 | 2009-08-15 10:57:00 | time to open paint up and do some editing i think :p | hueybot3000 (3646) | ||
| 801358 | 2009-08-15 10:58:00 | :p That's not an option Please excuse the crudeness of the file name... :o |
Renmoo (66) | ||
| 801359 | 2009-08-15 11:19:00 | On a graph in excel you would have an x, y, z, axis. What about showing the actual sheet and what version of excel may I ask? |
Sweep (90) | ||
| 801360 | 2009-08-15 11:27:00 | Good suggestion, Sweep. Excel 2007 Here's the worksheet: Attached file: helpme.jpg (www.imagef1.net.nz) (12 KB) (Change .jpg to .xlsx) Cheers :) |
Renmoo (66) | ||
| 801361 | 2009-08-15 11:30:00 | It usually does this based on how you have your data laid out; try rearranging your columns and rows of figures and see if this helps. | nofam (9009) | ||
| 801362 | 2009-08-15 12:04:00 | I've tried that, but to no avail | Renmoo (66) | ||
| 801363 | 2009-08-15 12:10:00 | AH!! I had the EXACT same problem while doing a 104 assignment last semester. Let me look around on my graph (if I still have it somewhere) and will post back if I remember how I did it. | qazwsxokmijn (102) | ||
| 801364 | 2009-08-15 12:11:00 | Go to your graph. Click on the bottom x axis (dunno why) - right click and choose format axis. Under the tab of scale. Change the following: Value (Y) axis crosses at ..... |
Nomad (952) | ||
| 801365 | 2009-08-15 12:14:00 | Go to your graph . Click on the bottom x axis (dunno why) - right click and choose format axis . Under the tab of scale . Change the following: Value (Y) axis crosses at . . . . . Hmmm . . . Can't find the tab "scale" |
Renmoo (66) | ||
| 1 2 | |||||