Hi all,
Have a pie chart where I have formated the Value data label to show millions using ($0.0,, "M") number format. EG. 11,796,143 displays as $11.8 M.
When I select to show Percentage in the data label options as well as Value, my value changes to a full dollar figure then displays a comma and then $0.0 M (which I assume is the percentage label coming through). EG. 11,796,143 displays as $11,796,143 , $0.0 M.
How do I get it to show as $11.8M , 20.1% ??
I am using Excel 2010.
Thanks in advance
Bookmarks