+ Reply to Thread
Results 1 to 6 of 6

Excel Chart delete individual Data Labels

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    24

    Excel Chart delete individual Data Labels

    I have attached a sample spreadsheet that has a Stacked Column Chart with data labels. I am trying to figure out if there is a way to selectively delete an individual data label for one column in the chart, while keeping the other data labels for the other columns, without having to delete the source data. There is a blue arrow pointing to the data label with a value of 0 that I wanted to delete while keeping the other data labels in tact. the blue arrow is pointing to the column for Project 3, and the Data label is for SeriesC. Thanks for any assistance/feedback.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-22-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    24

    Re: Excel Chart delete individual Data Labels

    I figured it out. I just needed to highlight the text in the individual data label and then right click and choose delete.

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

    Re: Excel Chart delete individual Data Labels

    You need to select the data labels first. Then select the individual data label to be deleted.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    09-22-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    24

    Re: Excel Chart delete individual Data Labels

    Hi Andy, that is the challenge I am having. When I select the data label I want to delete, Excel highlights all the other data labels in that category, in this case (SeriesC). So if I right click and then choose delete it deletes them all. It seems I need to select the text/data within the data label I want to delete and then right click and click delete and then Excel will only delete that individual data label. The production Excel spreadsheet I am working with is much more complex then the sample one I am uploading so trying to remember how to do this was frustrating. I used to do this within Pie Charts quite easily, many years ago and just forget how I did this. I thought it might be a data label format setting.

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

    Re: Excel Chart delete individual Data Labels

    You need to make 2 selections.

    First select a data label, which will select all data labels in the series. You should see dark dots selecting each data label.

    Now select the data label to be deleted. This should remove the selection from all other labels and leave the specific data label with white selection dots.

    Deletion now will remove just the selected data point.

  6. #6
    Registered User
    Join Date
    09-22-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    24

    Re: Excel Chart delete individual Data Labels

    thanks I just figured that out and was going to update post. the Production file I am working with is so complex and the column charts/labels are very small and crammed so it was hard to figure out at first. That is why I needed to make the sample file. Thanks again!

+ 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 can I create a XY graph with Labels and individual data points
    By albardit18 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2019, 03:17 PM
  2. Trying to access format for individual Axis labels on a chart
    By BryanTX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2018, 03:14 AM
  3. [SOLVED] Add the count of data to data labels to a pivot chart in excel
    By BizzyIzzy in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 04-01-2015, 04:11 PM
  4. Format individual axis category labels on chart
    By emm8080 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2012, 12:20 PM
  5. Replies: 1
    Last Post: 06-26-2012, 10:02 AM
  6. [SOLVED] Excel chart data labels showing % change instead of value?
    By MFritz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 10:05 AM
  7. Excel 2000 Scatter Chart cannot use data labels
    By Tom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2005, 02:06 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