excel chart - devide scale into 14 - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 11-28-2005, 02:59 PM   #1 (permalink)
True Techie
 
Join Date: Oct 2004
Posts: 123
Default excel chart - devide scale into 14

I'm using MS Excel in Office XP to create a spreadsheet for losing weight. Ive got all my data in and I've tried to create a chart based on this data. The problem i'm having is that the scale on the chart is divided into 10. This is obviously the default.

So, it goes 1, 2, 3....and in between each unit I can have 0.1, 0.2...up to 0.9 and then it goes to 2.

I want it to go 0.1, 0.2....up to 0.14 and then 2. This is becuase there are 14 pounds in a stone and I want to be able to accurately mark in each pound on he chart.

I know it sounds confusing, but please can anyone help?!!

Thanks!!
__________________

__________________
My Specs:
Windows Xp Home
Intel Celeron 2.66
704mb DDR Ram
SiS Real256E 64mb shared graphics
80Gb Hdd
CD/DVD writer
cooleddy4 is offline  
Old 11-28-2005, 09:22 PM   #2 (permalink)
Master Techie
 
Join Date: Oct 2003
Posts: 2,258
Default

format the cells to a number that contains 2 decimal places. Then start with 1.00 and end with 1.14 then put 2.00
You will have to do this over and over again, as excel is a .10 base... Good luck
__________________

Inaris is offline  
Old 11-29-2005, 06:31 PM   #3 (permalink)
True Techie
 
Join Date: Oct 2004
Posts: 123
Default

ive done the first bit, but I dont understand what you mean by "Then start with 1.00 and end with 1.14 then put 2.00".

Could you go over it in more detail please?

Thanks
__________________
My Specs:
Windows Xp Home
Intel Celeron 2.66
704mb DDR Ram
SiS Real256E 64mb shared graphics
80Gb Hdd
CD/DVD writer
cooleddy4 is offline  
Old 11-30-2005, 04:44 PM   #4 (permalink)
True Techie
 
Join Date: Oct 2004
Posts: 123
Default

can someone go over it in more detail please?
__________________
My Specs:
Windows Xp Home
Intel Celeron 2.66
704mb DDR Ram
SiS Real256E 64mb shared graphics
80Gb Hdd
CD/DVD writer
cooleddy4 is offline  
Old 12-04-2005, 07:42 PM   #5 (permalink)
True Techie
 
Join Date: Oct 2004
Posts: 123
Default

please?
__________________
My Specs:
Windows Xp Home
Intel Celeron 2.66
704mb DDR Ram
SiS Real256E 64mb shared graphics
80Gb Hdd
CD/DVD writer
cooleddy4 is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:54 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.