#### I've got a formula for stones and pounds - how do I get an excel .

```Hello,

I've got a column that displays a series of weights in stones & pounds (both
in the one cell). How do I get a chart to recognise and display in the same
format?

Regards,
mikelenno

```
 0
mikelenno (7)
1/23/2005 10:33:03 AM
excel.charting 18370 articles. 0 followers.

4 Replies
512 Views

Similar Articles

[PageSpeed] 34

```What is the format of the cells with stone & pounds
It is best to enter such values a 10 3/14 and format the cells with # ??/14
best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
> Hello,
>
> I've got a column that displays a series of weights in stones & pounds
> (both
> in the one cell). How do I get a chart to recognise and display in the
> same
> format?
>
> Regards,
> mikelenno
>

```
 0
bliengme5824 (3040)
1/23/2005 4:57:19 PM
```Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My
not-very-succinct-method so far includes 3 columns for stones/pounds/ounzes
to record weight once per week. I convert the 3 figures to give an overall
weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter
=INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell with
178.5 to give a cell with 12st 10.5lb. When I create a chart using a series
from the new column I can't get the Y axis to display the increments as
stones & pounds.

"Bernard Liengme" wrote:

> What is the format of the cells with stone & pounds
> It is best to enter such values a 10 3/14 and format the cells with # ??/14
> best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
> > Hello,
> >
> > I've got a column that displays a series of weights in stones & pounds
> > (both
> > in the one cell). How do I get a chart to recognise and display in the
> > same
> > format?
> >
> > Regards,
> > mikelenno
> >
>
>
>
```
 0
mikelenno (7)
1/23/2005 6:37:02 PM
```Y values must be numeric.
Suggest you plot with the decimal values and make a column with "st & lbs"
with intervals like 10 st 7 lbs, 11st 0 lbs ... and use Rob Bovey's XY Chart
http://www.appspro.com/utilities/utilities.asp
to label the y-axis
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
news:9CC13C1B-48F1-414E-B9E5-FAF15BF9286C@microsoft.com...
> Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My
> not-very-succinct-method so far includes 3 columns for
> stones/pounds/ounzes
> to record weight once per week. I convert the 3 figures to give an overall
> weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter
> =INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell
> with
> 178.5 to give a cell with 12st 10.5lb. When I create a chart using a
> series
> from the new column I can't get the Y axis to display the increments as
> stones & pounds.
>
> "Bernard Liengme" wrote:
>
>> What is the format of the cells with stone & pounds
>> It is best to enter such values a 10 3/14 and format the cells with #
>> ??/14
>> best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
>> --
>> Bernard V Liengme
>> www.stfx.ca/people/bliengme
>> remove caps from email
>>
>> "mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
>> > Hello,
>> >
>> > I've got a column that displays a series of weights in stones & pounds
>> > (both
>> > in the one cell). How do I get a chart to recognise and display in the
>> > same
>> > format?
>> >
>> > Regards,
>> > mikelenno
>> >
>>
>>
>>

```
 0
bliengme5824 (3040)
1/24/2005 12:59:04 PM
```Thank you Bernard, the chart labeler makes it a lot easier (got it from
http://www.appspro.com/Utilities/ChartLabeler.htm).

Regards,
mikelenno

"Bernard Liengme" wrote:

> Y values must be numeric.
> Suggest you plot with the decimal values and make a column with "st & lbs"
> with intervals like 10 st 7 lbs, 11st 0 lbs ... and use Rob Bovey's XY Chart
>       http://www.appspro.com/utilities/utilities.asp
> to label the y-axis
> best wishes
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
> news:9CC13C1B-48F1-414E-B9E5-FAF15BF9286C@microsoft.com...
> > Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My
> > not-very-succinct-method so far includes 3 columns for
> > stones/pounds/ounzes
> > to record weight once per week. I convert the 3 figures to give an overall
> > weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter
> > =INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell
> > with
> > 178.5 to give a cell with 12st 10.5lb. When I create a chart using a
> > series
> > from the new column I can't get the Y axis to display the increments as
> > stones & pounds.
> >
> > "Bernard Liengme" wrote:
> >
> >> What is the format of the cells with stone & pounds
> >> It is best to enter such values a 10 3/14 and format the cells with #
> >> ??/14
> >> best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
> >> --
> >> Bernard V Liengme
> >> www.stfx.ca/people/bliengme
> >> remove caps from email
> >>
> >> "mikelenno" <mikelenno@discussions.microsoft.com> wrote in message
> >> > Hello,
> >> >
> >> > I've got a column that displays a series of weights in stones & pounds
> >> > (both
> >> > in the one cell). How do I get a chart to recognise and display in the
> >> > same
> >> > format?
> >> >
> >> > Regards,
> >> > mikelenno
> >> >
> >>
> >>
> >>
>
>
>
```
 0
mikelenno (7)
1/25/2005 8:45:01 PM

Similar Artilces:

Looking for an excel function which can mirror opposite the data
Dear sir, There are 2 data sets is assumed running in A1 down, viz.: From A1 down to A10, are showing a set of number: from 1 to 10 In the cell from B1 to B10, are showing from 10 to 1, which is decreasing from 10 to 1. My question: I want to know is there any excel formula which I can place in B1 and pick A10's number; B2 pick A9's number and etc. I know there is an easy way to do it, just type "=A10" in the cell of B1, but it is quite difficult to do it when I have more than 200 number, e.g. A1 to A200. Thanks for your advice, Wilchong -- Message posted via OfficeKB...

Analysis Cubes
What are the minimum requirements for using the Excel Addin for Analysis Cubes? Do you need to have GP installed to use the Excel AddIn? I have some users that need to access GP data, but I donot want to have to install GP on their Workstations, how do I do this? I am using GP version 8.0. See below for the requirements: 1. Supported Operating Systems: Windows 2000 Server; Windows 2000 Service Pack 2; Windows 2000 Service Pack 3; Windows 2000 Service Pack 4; Windows Server 2003; Windows XP; Windows XP Service Pack 1 2. To use the add-in with Analysis Services 2005, the following compone...

How do I get a filter to "UPDATE" the rows selected?
Hey there! I am using Excel 2002 and I have a speadsheet that has prices in it. If I have the filter set to (the filter criteria is much more complex than this though) prices for items that cost >\$5.00. Of I change an item to 4.59, it should not be seen. How can I get it to re-update the rows shown, with out releaseing the filter and resetting it? Is there something like refresh.filter or anything like that? Thanks Phil AFAIK you must release and reset but a macro with a worksheet_change event could trigger this for you so that it would happen automatically. -- Don Guillett SalesAid...

excel #159
How do I prevent 2 files from opening up when I click on one file? What two files are opening? If it looks like: book1.xls:1 and book1.xls:2 Then you actually only have one workbook open--but you have two windows to that single workbook opening. Click on the window you don't want anymore and hit ctrl-w to close that window. Then save the workbook. ======== If that's not it, maybe you have another workbook in a folder named XLStart. Use windows start button and search for XLStart. Then look in each of those folders for a workbook file (*.xls). Move it or delete it if you'r...

where do office 2000 (including excel of course) service packs go
where do office 2000 (including excel of course) service packs go. I don't know why they don't give you the option of downloading and saving them before installing the various program updates and service packs. This way whenever I do a fresh reformat of my computer, i need to spend hours getting all the updates again off of the internet, where as if I could save thme, I would just have to re-install. Any help would be appreciated Don't know about Office 2000......never used it, but Office Download center offers you the choice of installing or saving to install file to disk....

Number of wsheets in an excel workbook???
hey guys, how many wsheets does one excel workbook have? I need to have about 66 - is that possible? Thanks. Maria -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31726 View this thread: http://www.excelforum.com/showthread.php?threadid=521656 Yes I have created a workbook with more sheets in it that that. obviously depending on the amount of data on each sheet your workbook could be getting quite large and possibly unmanageable! I guess you will have to try it! D...

moving text from a word document to excel
I'm moving a large amount of text from word documents to an excel spreedsheet, and I have a few questions: 1. When I copy/paste text from the document to the spreedsheet, the text will sometimes expand the cell very large. How can I keep all the cells the same size? 2. When I click on a cell that has text in it to read it, sometimes it will only show the text in a long downwards column, whereas other times it shows it as a big 'blurb' to the right side (which makes it easier to read). How can I set it up so it is not in a long column? 3. How can I insert cells without h...

Excel-Multiple Cells Being Hi-lited
Sometimes when I'm setting up a worksheet and I left-click in a cell, multiple cells in the same column are hi-lited. After it happens the first time, it continues as I move through the worksheet, reducing my ability to get work done considerably. After some trial and error, it seems to occur when I've been adding and/or deleting columns and/or rows, after a header has been installed. I can move throughout the worksheet using the arrow keys, but it is a time consuming and cumbersome technique. I think the version I'm using is Office Professional 2007 (file extensi...

memory problem of Excel 2003 copy & paste
Hi all, I am using Excel 2003 for some project. I am having 2GB C drive harddisk space. After a while, the Excel begins to be extremely slow in copy and paste... It takes about half an hour to copy and paste just a few cells... I've consulted people. It seems a memory problem. But I cannot close my windows and kill the processes, because I am running long-running (overnight) jobs... I cannot reboot either. Is there a way to clean the memory and let Excel 2003 clipboard function properly without rebooting or killing my 4 long-running processes? Thanks! p.s. I am sure this is an is...

in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot I once tried 360 cells and got a wonderful Moiré pattern Why not just experiment with 1, 2, 3 dozen and see for yourself if the result is acceptable ? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "bsalohcin" <bsalohcin@discussions.microsoft.com> wrote in message news:F9CF7752-1816-4DCE-BF82-9C25033AE888@microsoft.com... > How many rows or columns of data can the pie chart plot According to MS:- Data series in one chart 255 (max limit) Data points in a...

How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any advice or help--I'm a bit of a novice to this! ...

Excel Events Conflict with VB and C# AddIns
Hi, I have two com addins running in Excel. One is written in VB and the other in C#. Both addins are interested in the Workbookopen event. When the event is triggered the c# code captures the event but the VB code does not. If i disable the c# addin then the vb code works. Looks like the c# addin is somehow blocking the vb events. Anyone know how to fix this? Many thanks, Andy There is only one WorkbookOpen event, so once one add-in hooks it, there is nothing for the other one to hook. If you are hooking the WorkbookOpen event in your add-ins, this is likely your problem. You may need...

help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha tells number of gallons of alcohol per foot/inch/fraction. On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i cells R5 and T5. I want these numbers to lookup the number of gallon off of the P&G 103 worksheet. For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2" These two numbers should be added together and multiplied by the numbe ...

cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and got it installed then opened Outlook and said it could not setup database. Is BCM 2007 compatible with Enterprise and Windows 7. Is there a work around? ...

Portrait only printing in Excel
I have an interesting problem. I have a workstation (Dell Pentium IV XP PRO) that has Office 2k on it. When I/we try to print to a networked printer, the document will only print in portrait no matter what changes I make to page settings or printer settings. We are on Active Directory, so as long as the documents are submitted from a different computer, it will print fine. Any suggestions? This could be a complete waste of your time, but the first thing I'd try is to reinstall the printer driver. (maybe even get a fresh driver from the printer manufacturer's web site???) Howa...

VBA & Excel
Hi, I don't know a lot about VBA. I need to make an Exe file with VB to give 3 buttons each button starts an excel work book (book1, book2,book3). I am thinking of a form that appears on the screen. When the "Exit" button is cliked it will make an other copy of the 3 excel files on another folder (say: d:\data) for example (like a back up copy). Can any one help thanks Hi You can not make exe files with VBA. If you can use VB5 or VB6 instead then adapt the VBA code from http://www.erlandsendata.no/english/index.php?d=envbaolecontrolexcel see also http://www.erlandsendata...

Create Folders in Directory with Excel VBA?
Hi, Is there a way to create folders with a specfic names, and have them saved in a directory. I have an excel file with 250 records with my desired folder names. I want to avoid having to through the process of selecting <File | New | Folder> then naming the folder -- 250 times! I imagine there's an easier way with VBA... please help! Thanks It can be done something like this. Attatch code to a command button on the sheet. Alter code to suit your reqirements. Test on a dummy workbook first until you get it to work the way you want. Please note that there are practical lim...

copy and paste excel freeze
Hi, I am running Office 2003 in Windows 2000 Pro. try to copy the excel worksheet and paste to another new workshee takes long and the system seems freeze for a while b4 the process finish anyone have samme experience? ...

I have a database written in programme called Paradox and I would like to fransfer it into Excel. You may find this a bit tricky, depending on the complexity of links between tables and queries within the original database. Tables hold information, and queries manipulate that data; if you need data that is the result of a Paradox query you will not, AFAIK, be able to import that to Excel. You'll have better luck if you need data from tables. In a quick web search I notice that converter software is available, which might be a fallback position in case on-board export capability withi...

Subtotal Lines in the wrong place Excel 2003
When nesting subtotals in Excel 2003, the subtotal lines are not in the correct position. Is there a fix or a work around for this problem? Example: Craft Code Crew Count BA Elec 1 BA Elec 1 BA Total 2 Elec Total 2 Hi AFAIK you should start with the subtotal for the right-most column and then add the other columns step by step -- Regards Frank Kabel Frankfurt, Germany "k2quayle" <k2quayle@discussions.microsoft.com> schrieb im Newsbeitrag news:FF252538...

Excel 97 Worksheet Protection and cell colour
Hi there, One of our users has setup a worksheet will a small range of cells that are locked (they have formulas in them), he then protects the sheet. He then wants to change the colour of some of the other cells, these cells are not locked, but he cannot change the colour of the cells. Is there an obvious solution? Cheers, Andy Hi AFAIK you can't do this in Excel 97 without first removing the protection -- Regards Frank Kabel Frankfurt, Germany andy wrote: > Hi there, > > One of our users has setup a worksheet will a small range of cells > that are locked (they h...

excel locks up after selecting a cell #2
excel locks up after selecting a cell. When ever, I select a Cell, that will automatically selects all the cell and this freezes the entire computer. Can any body who would help me resolve this issue? Please help.... ...

Where has the data map tool gone to in Excel 2003?
Cannot find it in 2003. Was there in earlier versions of Excel. It's gone as of Exel 2002. Here is MS's statement and a link to another program for map making. http://office.microsoft.com/en-us/assistance/HA010346591033.aspx tj "macray" wrote: > Cannot find it in 2003. Was there in earlier versions of Excel. If it still resides on the hard drive, you can use it from later Excel versions, through the Insert Object dialog. But I think uninstallation is pretty good at wiping it out. In my case, I have multiple versions of Excel installed on one machine, so Excel 2003...

Pointing to correct macro path using excel custom toolbar
I have created an excel 2000 template (.xlt) containing a number o macros. When I open copies of this template on various pcs, the macro function correctly, except I cannot successfully run the macros usin the custom toolbar I created, because (I think) within the toolbar th paths to the macros are pointed to the original location on my pc. An advice on how I can resolve this would be gratefully received -- Message posted from http://www.ExcelForum.com Have you thought about building the toolbar when the file opens? Or maybe separating the worksheet portion of the template from the code pa...

Stop excel from reporting replacements
How do I get excel from popping up the window that tells how many entries its replaced when I do a Ctrl-H. I have to edit a lot of entries and this is something I didn't have to put up with in Office 97 I'm not sure you can stop it (I couldn't). But if your fingers are on the keyboard, hit the enter key to dismiss it. (Or try hitting the enter key twice really quickly (with replace all having focus). It might not be noticeable (much). Chris wrote: > > How do I get excel from popping up the window that tells how many entries its > replaced when I do a Ctrl-H. I ha...