ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Changing the scale to custom text (https://www.excelbanter.com/charts-charting-excel/94311-changing-scale-custom-text.html)

Steve D

Changing the scale to custom text
 
Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?
--
Thank You,
Steve

Andy Pope

Changing the scale to custom text
 
Hi,

Use as custom number format #,k

Cheer
Andy

Steve D wrote:
Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?


--

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

Anna

Changing the scale to custom text
 
I can't get this to work it just brings up k instead of the number with K
after it do you know what I am doing wrong?

"Andy Pope" wrote:

Hi,

Use as custom number format #,k

Cheer
Andy

Steve D wrote:
Hello, I am trying to change my scale from say 5000 to 5k, is there any way
to do this?


--

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



All times are GMT +1. The time now is 07:13 AM.

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