+ Reply to Thread
Results 1 to 3 of 3

Chart - Data Label Format Refuses to Change

  1. #1
    Registered User
    Join Date
    12-12-2014
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    43

    Chart - Data Label Format Refuses to Change

    Capture3.JPG

    Attached image. Fourth bar from the right. Top orange rectangle.

    You'll notice that I have the labels on this orange series formatted as "series name". 3 of the 4 bars are properly formatted and display the series name. The one incorrect bar (fourth from the right, top) refuses to display the series name and instead displays the value "1". The value box is clearly not selected for this series. Why is there this one exception. I want the series name "NC" to show on this bar, just like the others.

    I've tried changing the one data point and then changing it back (to refresh the data) but it didn't help.

    [PS - DONT LOOK AT THE IMAGES BELOW THIS LINE, I CANT FIGURE OUT HOW TO DELETE THEM]
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Chart - Data Label Format Refuses to Change

    Hi,

    You'll need to upload the workbook. We can't debug from a picture.

    Would you also change the location in your profile to something sensible. It's there for a purpose and often helps when we need to consider regional settings and date presentations.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Chart - Data Label Format Refuses to Change

    I think it was edited manually
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. [SOLVED] Format a data label on a chart
    By Aland2929 in forum Excel General
    Replies: 3
    Last Post: 10-28-2012, 07:31 AM
  2. Macro to format data point and add label in chart
    By Scottmk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2010, 08:54 AM
  3. [SOLVED] How change dimensions of data label text box in pie chart?
    By Gouden Willem in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-07-2006, 08:20 AM
  4. [SOLVED] Pivot Chart Data Label Format Question
    By Dominic in forum Excel General
    Replies: 3
    Last Post: 03-01-2006, 04:00 PM
  5. [SOLVED] change the data label of an chart to show qty
    By Trever B in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2005, 11:05 PM

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