ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   CHANGE Y AXIS Value (https://www.excelbanter.com/charts-charting-excel/189996-change-y-axis-value.html)

CINDY

CHANGE Y AXIS Value
 
I need to change the value on the Y Axis to inches but cannot figure out the
right way to go.

Thanks,
Cindy

Andy Pope

CHANGE Y AXIS Value
 
Hi,

The scaling is not really done in inches or centimeters or any
measurement system. It's purely a numeric scale.

Cheers
Andy

Cindy wrote:
I need to change the value on the Y Axis to inches but cannot figure out the
right way to go.

Thanks,
Cindy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Dave Curtis

CHANGE Y AXIS Value
 
Hi,
Do you mean that you want the values on your y axis to show as, for example,
1", 2", 3" etc?

If so, you can select the axis and apply a custom number format of 0"''"

Note that that is two single quotes bracketted by double quotes.

Dave

url:http://www.ureader.com/msg/10296162.aspx


All times are GMT +1. The time now is 04:22 PM.

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