+ Reply to Thread
Results 1 to 3 of 3

Chart data Label decimals reflecting the data source

  1. #1
    Registered User
    Join Date
    04-16-2015
    Location
    Oxford
    MS-Off Ver
    2010
    Posts
    2

    Chart data Label decimals reflecting the data source

    Hi, Does anyone know how you can set the number of decimals in a data label to match what's in the table?
    This needs to be dynamic as the I have conditional formatting on a table which alters the number of decimals based on the selection and ideally would like it to be reflected in the data labels in the chart so when the number of decimals shown in the table changes, it does the same in the chart.

    I already have it linked to source but that doesn't seem to do the job.
    Thanks

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

    Re: Chart data Label decimals reflecting the data source

    The data label will not reflect a number format that is the result of condition formatting.

    You can format the number and use that. The attached example displays random numbers with the number of decimals specified either determines the CF to use or the output of the TEXT function.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-16-2015
    Location
    Oxford
    MS-Off Ver
    2010
    Posts
    2

    Re: Chart data Label decimals reflecting the data source

    perfect :-)
    thanks for you help

+ 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. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  2. Replies: 0
    Last Post: 07-12-2012, 11:27 AM
  3. How do you have one source data in a chart flow into a 2nd source of data?
    By Disintegrate in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-06-2009, 09:26 AM
  4. Chart not plotting new data anymore, source data correct.
    By mr2mike in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-29-2008, 07:25 PM
  5. Update a chart immediately after inputting data into data source
    By MELMEL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-01-2005, 05:40 PM
  6. Possible to add second data label to pie chart?
    By jpwolf00 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-10-2005, 10:05 AM
  7. Hide the data label for a data table in a chart
    By Kathy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-23-2005, 11:08 PM

Tags for this Thread

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