Hi,

Firstly I'd like to apologise if this post is initially a little confusing or long winded, but I haven't got much experience with Excel or the subject matter I'm working with.

Basically I have 65 Stress/Strain scatter graphs that I've previously plotted using excel. I'm now trying to find the gradient of each. I have 6 examples completed that I did with the help of my university professor, which will hopefully help anyone get the just of what I'm saying. Unfortunately my professor has gone away for 3 weeks so I can't ask him for help. I'd really like to get this work done and wondering if anyone here can help me.

As best as I can explain, I need to only display the part of the graphs in question between 2 points on the x axis (namely 0.0025 and 0.0050/ or 2.50 E-03 and 5.00E-03), making anything either side of these point invisable (not formatting the axis to only display between these two points). To make more clear I have 65 graphs which need to get from picture 1, which they are atm to picture 2. I'll be ever so grateful if anyone can help me out on how to do this in Excel as I'm at a loss.

Picture 1

http://img220.imageshack.us/img220/1552/picture1jk.jpg

Picture 2

http://img3.imageshack.us/img3/4043/picture2ea.jpg

Thanks

PS - I'm using 2007