Author Topic: Can some1 help with excel?  (Read 2849 times)

Offline twiggy

  • Not said much yet
  • **
  • Posts: 35
Can some1 help with excel?
« on: 23 February 2005, 16:08 »
Hi folks I'm currently doing a project for college and I need to make a break even chart. Now all the excel stuf is done but when i come to make the line graph the lines don't start on the left   

I have attached the file so you can take a look (table is in Chart 3 and its getting the info from Sheet2)

http://www.angeltowns.com/members/pcuk/wtf.xls

Can some one please explain hoe I can get the lines to start from the left?

Yes i have clicked time bound in the axies set-up but the bottom dosn't show how many plants sold.

Thanks,
Mark

Offline jte

  • I live here
  • *****
  • Posts: 611
Re: Can some1 help with excel?
« Reply #1 on: 23 February 2005, 16:36 »
Right click over the X axis

click Format axis
 
click Scale tab, untick "value Y Axis crosses between catagories.

Oh and You've spelt Variable wrong.

Hope this helps.


A VR6 isn't a way of life, it's just a car.

Offline twiggy

  • Not said much yet
  • **
  • Posts: 35
Re: Can some1 help with excel?
« Reply #2 on: 23 February 2005, 17:27 »
Yeh thanks sorted it there are a few spelling mistakes on there just aint got around to changing them all, jsut trying to get the thing to work more important

Fred Flintstone

  • Guest
Re: Can some1 help with excel?
« Reply #3 on: 25 May 2005, 13:44 »
I may be very new to this forum but...
What has Exel got to to with VW Motorsport?? :huh:

Anyway glad you got sorted! :smiley:

mrwotto

  • Guest
Re: Can some1 help with excel?
« Reply #4 on: 27 May 2005, 13:25 »
I may be very new to this forum but...
What has Exel got to to with VW Motorsport?? :huh:

Anyway glad you got sorted! :smiley:

He posted in the wrong section by mistake

Fred Flintstone2

  • Guest
Re: Can some1 help with excel?
« Reply #5 on: 27 May 2005, 21:28 »
I know, glad he got sorted.