+ Reply to Thread
Results 1 to 3 of 3

How to stop #N/A in data labels

  1. #1
    Registered User
    Join Date
    09-23-2007
    Posts
    33

    How to stop #N/A in data labels

    The issue is in cells BC42: BK42
    I have tried using #"" but cant seem to get rid of it, it does not appear in the other bar charts.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: How to stop #N/A in data labels

    The problem is your formulas in U38:U59. Take the formula from U37 and paste it down through U63. Problem solved.

  3. #3
    Registered User
    Join Date
    09-23-2007
    Posts
    33

    Re: How to stop #N/A in data labels

    Thank you, I would never have found that issue.

    Now solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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