PC Pals Forum
Technical Help & Discussion => Windows PCs & Software: Help, News & Discussion => Topic started by: twiggy on February 23, 2005, 15:53
-
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
-
Sorry Twiggy,
I've never used Excel, and don't know how to use it, but as I see no one answering you, I'm just wondering of your file. Not sure though I understood correctly what you mean.
I have your lines already on the left side, and everything seems to me normal.
Is it a problem on your system, or it's me who don't see what you mean?
-
Twiggy,
I see what you mean, I think.
Is it so that the y axis crosses the x at zero? So that there is not a gap between your data and the axis?
If so you just need to hightlight the x axis by clicking on it. Once you have this selected right click on it. Click "Format Axis". Once you have done this you should see a popup box. Make sure you are on the scale tab. Once you have done this go down to the option "Value (Y) axis crosses between categories". Make sure it is not selected and you should see your graph shifted and thus having no gap.
If thats not what you meant could you ellaborate a bit more please :-)
-
Thanks why that was the problem just un-clicked it and it was sorted.
Cheers.