+ Reply to Thread
Results 1 to 3 of 3

Data Lable in $Millions ($0.0,, "M") and showing percentage label

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Data Lable in $Millions ($0.0,, "M") and showing percentage label

    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

  2. #2
    Registered User
    Join Date
    10-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Data Lable in $Millions ($0.0,, "M") and showing percentage label

    Applogies for the mis-spell of Lable

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934

    Re: Data Lable in $Millions ($0.0,, "M") and showing percentage label

    Apply the number format to your source data instead of the data label.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-01-2012, 04:35 PM
  2. Pivot Tables: Filtered PT Showing "% of total" unfiltered data
    By ANS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-07-2012, 05:22 AM
  3. "Totals" Data label in a stacked chart
    By gvb in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-25-2008, 09:42 PM
  4. Replies: 3
    Last Post: 05-01-2007, 12:03 PM
  5. scatter plots and "label" as ("X" value1, value2)
    By shabnam in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1