Hi Prashant,
Go to FORMAT CELLCustom _($#,k
this will solve your problem...
Cheers,
Bakul
--- On Thu, 4/9/09, Prashanth Banneni praba...@gmail.com wrote:
From: Prashanth Banneni praba...@gmail.com
Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph
To:
Right click the axis format axis
Then select the Number tab and select the Custom category.
In the format code, type in $###K
Then select the axis options tab and select the display units as
Thousands
This should be what you are looking for.
Angelo
Use formula as
=Cell no / 1000
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Prashanth Banneni
Sent: Thursday, April 09, 2009 12:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph
Change the units displayed on the value axis
If your chart values consist of large numbers, you can make the axis
text shorter and more readable by changing the display unit of the
axis. For example, if the chart values range from 1,000,000 to
50,000,000, you can display the numbers as 1 to 50
