(Msg. 1) Posted: Mon Nov 10, 2008 5:53 am
Post subject: Custom Format Y-axis; '$1.6 K' ? Archived from groups: microsoft>public>excel>charting (more info?)
What code sequence do I choose, (edit), to achieve this?
Boswell
(Msg. 2) Posted: Mon Nov 10, 2008 10:10 am
Post subject: Re: Custom Format Y-axis; '$1.6 K' ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On either the y-values on the worksheet or the y-axis, use a custom format
such as #.0, "K"
Need this in VBA? Just record a macro as you do it.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Boswell" <boswell6.RemoveThis@sbcglobal.net> wrote in message
news:D73B6256-2166-4DC8-A53F-000A9729F83E@microsoft.com...
> What code sequence do I choose, (edit), to achieve this?
> Boswell
(Msg. 3) Posted: Mon Nov 10, 2008 10:10 am
Post subject: Re: Custom Format Y-axis; '$1.6 K' ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
1. Right-click the Y axis and choose Format Axis.
2. On the Number tab choose Custom
3. In the Type box enter
$#.0, K
If this helps, please click the Yes button
--
Thanks,
Shane Devenshire
"Bernard Liengme" wrote:
> On either the y-values on the worksheet or the y-axis, use a custom format
> such as #.0, "K"
> Need this in VBA? Just record a macro as you do it.
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme > remove caps from email
>
> "Boswell" <boswell6 DeleteThis @sbcglobal.net> wrote in message
> news:D73B6256-2166-4DC8-A53F-000A9729F83E@microsoft.com...
> > What code sequence do I choose, (edit), to achieve this?
> > Boswell
>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office