decimal point position for less than 1 million

[BethG]

I have a chart based on a worksheet with values both above and below 1,000,000. The chart labels show values above 1 million correctly (e.g., 2,500,000 is represented as 2.5 M) but for values under 1 million, it puts the decimal point after the "M" rather than befor the number (e.g., 520,000 should be represented as .52 M, but instead looks like "52M."

Anyone know how to correct this?

Thanks!

[Muhammed Rafeek M]

Hi
I can help you. Please send me that file to [email protected] i will reply
you.
Thanks and regards
Muhammed Rafeek M

"BethG" wrote:

>
> I have a chart based on a worksheet with values both above and below
> 1,000,000. The chart labels show values above 1 million correctly
> (e.g., 2,500,000 is represented as 2.5 M) but for values under 1
> million, it puts the decimal point after the "M" rather than befor the
> number (e.g., 520,000 should be represented as .52 M, but instead looks
> like "52M."
>
> Anyone know how to correct this?
>
> Thanks!
>
>
> --
> BethG
> ------------------------------------------------------------------------
> BethG's Profile: http://www.excelforum.com/member.php...o&userid=36510
> View this thread: http://www.excelforum.com/showthread...hreadid=562689
>
>

[Tushar Mehta]

That must be the result of a custom format that you (or someone else)
created.

You may want to check the format (double-click the y-axis and select the
Number tab) and consider something like
[<1000000]0.0,,"M";0,,"M"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> I have a chart based on a worksheet with values both above and below
> 1,000,000. The chart labels show values above 1 million correctly
> (e.g., 2,500,000 is represented as 2.5 M) but for values under 1
> million, it puts the decimal point after the "M" rather than befor the
> number (e.g., 520,000 should be represented as .52 M, but instead looks
> like "52M."
>
> Anyone know how to correct this?
>
> Thanks!
>
>
> --
> BethG
> ------------------------------------------------------------------------
> BethG's Profile: http://www.excelforum.com/member.php...o&userid=36510
> View this thread: http://www.excelforum.com/showthread...hreadid=562689
>
>