Hello, how do i graph Height using Microsoft Excel 2010?

Question

I'm having a problem graphing the height using feet and inches, i have no idea how to do it so i converted it into centimeters and now they have gaps.

Can someone tell me how to input feet and inches using excel? 

Thank you

Moved from Windows 7 Programs Forum.

Answer 1

There is some problem in your custom formatting.

1. You need to input numbers as 505, 511, 604 like this
2. CTRL+1
3. Choose Custom and in Type: , put following

0"'"00"''"

OR

0"ft"00"in"

4. Then plot the graph.

OR

Is it possible for you to upload your sheet to onedrive?

I will suggest that you upload your Excel workbook to onedrive and make sure that it doesn't contain any confidential data which violates your organization's policy. If it does contain confidential data, you may look into considering replacing confidential data with dummy data.

To upload to onedrive -

1. Login to https://onedrive.live.com/
2. Open the public folder.
3. Click Upload in the top.
4. After uploading, right click it and choose share.
5. Click Get a Link.
6. In the option, choose public.
7. Create Link
8. Post the link here.

Answer 2

someone please?

Answer 3

See if below approach solves your problem -

Select the column which has height and apply either of the below custom format

0"'"00"''"

OR

0"ft"00"in"

The restriction is that you will have to enter enter height like 505 for 5ft5inches i.e. last two digits should be of 2 digits.

Answer 4

It does not work :/

Answer 5

Can you post the results which you are getting after applying custom format?