ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Feet and Inches (https://www.excelbanter.com/charts-charting-excel/231113-feet-inches.html)

HighJumpTom

Feet and Inches
 
I am trying to make a chart using feet and inches on the y-axis. I know that
I could convert to just inches, but I'd really rather not if it can be
avoided. I'm using Microsoft Excel 2008 for Mac version 12.1.5.

HelpExcel.com[_2_]

Feet and Inches
 
Tom,

You can convert inches to feet/inches with the following formula:

=INT(F18/12) & "' " & MOD(F18,12) & """"
--
Regards,
Eddie
http://www.HelpExcel.com


"HighJumpTom" wrote:

I am trying to make a chart using feet and inches on the y-axis. I know that
I could convert to just inches, but I'd really rather not if it can be
avoided. I'm using Microsoft Excel 2008 for Mac version 12.1.5.


David Biddulph[_2_]

Feet and Inches
 
Perhaps, Eddie, you could explain how to use the result of that as the Y
axis value in a chart, which is what the OP was asking?
--
David Biddulph

HelpExcel.com wrote:
Tom,

You can convert inches to feet/inches with the following formula:

=INT(F18/12) & "' " & MOD(F18,12) & """"

I am trying to make a chart using feet and inches on the y-axis. I
know that I could convert to just inches, but I'd really rather not
if it can be avoided. I'm using Microsoft Excel 2008 for Mac version
12.1.5.




HighJumpTom

Feet and Inches
 
David and Eddie -

Thanks to both of you. I'm trying to do exactly what David mentions below -
get the y-axis scale to display in Feet and Inches. If it helps - what I'm
trying to do is create a bar chart of the different heights each of my high
jumpers has cleared this season. So, I'd really like the y-axis to begin at
5' 0", end at 6' 2" and go in 2" steps. Any help in doing this would be
appreciated.

Tom

"David Biddulph" wrote:

Perhaps, Eddie, you could explain how to use the result of that as the Y
axis value in a chart, which is what the OP was asking?
--
David Biddulph

HelpExcel.com wrote:
Tom,

You can convert inches to feet/inches with the following formula:

=INT(F18/12) & "' " & MOD(F18,12) & """"

I am trying to make a chart using feet and inches on the y-axis. I
know that I could convert to just inches, but I'd really rather not
if it can be avoided. I'm using Microsoft Excel 2008 for Mac version
12.1.5.






All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com