GolfGTIforum.co.uk

General => Shows, events, track days, motorsport => Topic started by: twiggy on 23 February 2005, 16:08

Title: Can some1 help with excel?
Post by: twiggy 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

Title: Re: Can some1 help with excel?
Post by: jte 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.

Title: Re: Can some1 help with excel?
Post by: twiggy 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

Title: Re: Can some1 help with excel?
Post by: Fred Flintstone 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:

Title: Re: Can some1 help with excel?
Post by: mrwotto on 27 May 2005, 13:25

Quote from: Fred Flintstone 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:

He posted in the wrong section by mistake

Title: Re: Can some1 help with excel?
Post by: Fred Flintstone2 on 27 May 2005, 21:28

I know, glad he got sorted.