PDA

View Full Version : Excel graph woes - can't get the axis line to the left



Renmoo
15-08-2009, 10:23 PM
Attached file: totallywtf.png (http://www.imagef1.net.nz/files/totallywtf.png) (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!

hueybot3000
15-08-2009, 10:57 PM
time to open paint up and do some editing i think :p

Renmoo
15-08-2009, 10:58 PM
:p

That's not an option

Please excuse the crudeness of the file name... :o

Sweep
15-08-2009, 11:19 PM
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?

Renmoo
15-08-2009, 11:27 PM
Good suggestion, Sweep.

Excel 2007

Here's the worksheet: Attached file: helpme.jpg (http://www.imagef1.net.nz/files/helpme.jpg) (12 KB)

(Change .jpg to .xlsx)

Cheers :)

nofam
15-08-2009, 11:30 PM
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.

Renmoo
16-08-2009, 12:04 AM
I've tried that, but to no avail

qazwsxokmijn
16-08-2009, 12:10 AM
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.

Nomad
16-08-2009, 12:11 AM
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 .....

Renmoo
16-08-2009, 12:14 AM
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"

Nomad
16-08-2009, 11:19 AM
I'm running Excel 2002. You see Format Axis?

qazwsxokmijn
16-08-2009, 12:57 PM
Alright, I give up. I was toying with the graph to remember what I did. I think nofam's suggestion is what I did to correct my graph, though obviously it doesn't work for you.....

Sweep
16-08-2009, 01:18 PM
Only just received the Excel document but I have to go fix another computer.

I will have a look later.

Good to know that I use Excel 2007.

Renmoo
16-08-2009, 02:51 PM
Problem solved by instructing the vertical axis to cross at a specific point on the left side of the graph.

Cheers guys :thumbs:

Renmoo
16-08-2009, 04:37 PM
Another stupid question:

The leftmost data point is plotted right on the vertical axis. How should I go about in creating a space?

Attached file: furtherhelp.jpg (http://www.imagef1.net.nz/files/furtherhelp.jpg) (14 KB)

Cheers :)

Nomad
16-08-2009, 04:49 PM
You should be able to use the same method and adjust the values to a more -ve value. That should shift the line more to the left - as it "crosses".

Renmoo
16-08-2009, 08:29 PM
Yup, that fixes it.

Issues like these have not rose up before until today, for some strange reasons...

qazwsxokmijn
16-08-2009, 08:54 PM
Issues like these have not rose up before until today, for some strange reasons...
Usually such issues occur for me the day before the assignment is due. :D

Renmoo
16-08-2009, 09:23 PM
Usually such issues occur for me the day before the assignment is due. :D
Good old Murphy's law :D

Well, mine is due in a week's time... :p

Sweep
16-08-2009, 10:05 PM
Just got back home.

Pleased to see you have it sorted.