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

 Techist - Tech Forum excel chart - devide scale into 14

 11-28-2005, 01:59 PM #1 (permalink) True Techie   Join Date: Oct 2004 Posts: 123 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
 11-28-2005, 08:22 PM #2 (permalink) Master Techie   Join Date: Oct 2003 Posts: 2,258 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 __________________ __________________
 11-29-2005, 05:31 PM #3 (permalink) True Techie   Join Date: Oct 2004 Posts: 123 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
 11-30-2005, 03:44 PM #4 (permalink) True Techie   Join Date: Oct 2004 Posts: 123 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
 12-04-2005, 06:42 PM #5 (permalink) True Techie   Join Date: Oct 2004 Posts: 123 please? __________________ My Specs: Windows Xp Home Intel Celeron 2.66 704mb DDR Ram SiS Real256E 64mb shared graphics 80Gb Hdd CD/DVD writer

 Thread Tools Display Modes Linear Mode

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

#### Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

#### Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

All times are GMT -5. The time now is 03:36 AM.