Why does Microsoft Excel do this with graphs and how can I fix it?

Can you e-mail me the file? I will play with it. You should know my e-mail Inverted Treestump..

I explained where I think you might have gone wrong in my return email to you.

Riiiiiiiiight so because I was selecting them from different tables (one under the other) it wasn’t making an x-y relationship? Okay so I have to make the columns I’m using on the same rows… I swear I tried that haha I guess not. Thanks so much for your help!

Okay I think it wasn’t working when I copy pasted my required columns to be next to each other because the columns in my second table were excel calculations depending on the first table and the position on the excel grid so when I copy pasted one over it stuffed up the equations and the graph. If I copy back my columns from my word document with the values rather than the equation it looks like I’m right.

I sent the file back to you so you can see what I did. (I even managed to learn how to set up ChartSheets and to format axis & legend labels, etc.

It was so much easier in Office 2000!

I hope you’ve got it now, because I need sleep!

I do, thanks so much! I’m going to install windows on my mac soon and use Office 2000 next time I think :P

Hokay. I can rest in peace now.

In a manner of speaking.