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

Hello, the graphs looks like this when i input them.

Answer 3

Oh wow, THANK YOU SO MUCH!!!

hugs

ooops, one last question

my graph started to look like this.

can you please tell me how to edit it so it doesn't have the gaps?

Thank you

Answer 4

Nvm i fixed it. Thank you once again!

Answer 5

Glad that this helped you. Request you to mark relevant response as Answer so that thread can be closed and others can also benefit.