+ Reply to Thread
Results 1 to 4 of 4

Excel 2013 Chart label not displaying

Hybrid View

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Excel 2013 Chart label not displaying

    Hi everyone,
    I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount.
    I was wondering if the problem is a common one, or if there is a more permanent solution.
    I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?
    Many thanks in advance for your help.
    Cheers,
    Spero.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Excel 2013 Chart label not displaying

    Hi,

    Did you try deleting that particular pie chart and creating a new one? Sometimes it works.

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Excel 2013 Chart label not displaying

    Hi Chatrody,
    Yes, I had tried that previously and it did work then, but now it has arisen again. Deleting and replacing takes a lot longer than the cloning process. Part of the problem is that the original file is distributed to a number of users who input their own data. My role is to keep it together while they build their own files. After a time, i think it starts generating this kind of error when more and more users copy their files from the original. I have various protections in place to stop anyone changing formulas, but I can't do the same for charts, as it prevents formatting as well. Frustrating.

  4. #4
    Registered User
    Join Date
    02-18-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel 2013 Chart label not displaying

    I just wanted to say I also have this problem and your solution helped me. I was not able to get the number in the series for one set on the graph after updating the graph. I couldn't figure it out. This helped a bunch. Thanks!

+ 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. How to make a Clustered Cylinder Chart in Excel 2013?
    By Anodos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2014, 04:35 PM
  2. Secondary non-proportional x-axis on chart (Excel 2013)
    By mayache in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-24-2013, 07:16 AM
  3. [SOLVED] paired bar chart displaying difference as the data label
    By rlowrance in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-05-2013, 09:01 PM
  4. [SOLVED] Data label on chart not displaying what I expect?
    By Aland2929 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-05-2013, 09:08 AM
  5. [SOLVED] Creating scattering chart in excel 2007/2010/2013
    By elad.edri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2013, 10:02 AM

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