ExcelBanter - Y axis scale

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Y axis scale (https://www.excelbanter.com/charts-charting-excel/107382-y-axis-scale.html)

terry

Y axis scale

My Y axis scale is from 0 to 100.
Now I would like is to keep 0 to 100 scale of y axis, but only remove the
charator "0" beside the scale.
Can anyone tell me how?

Andy Pope

Y axis scale

Hi,

Use a custom number format on the y axis.

General;General;

Cheers
Andy

Terry wrote:
My Y axis scale is from 0 to 100.
Now I would like is to keep 0 to 100 scale of y axis, but only remove the
charator "0" beside the scale.
Can anyone tell me how?

--

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

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