+ Reply to Thread
Results 1 to 3 of 3

How to stop #N/A in data labels

  1. 08-20-2019, 04:58 PM #1
    juco
    juco is offline
    Registered User
    Join Date
    09-23-2007
    Posts
    38

    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
    Reply With QuoteRegister To Reply
  2. 08-20-2019, 05:08 PM #2
    brant.wheeler
    brant.wheeler is offline
    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.
    Reply With QuoteRegister To Reply
  3. 08-20-2019, 05:28 PM #3
    juco
    juco is offline
    Registered User
    Join Date
    09-23-2007
    Posts
    38

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

    Thank you, I would never have found that issue.

    Now solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine Row Labels and Column Labels to creata single list, no blanks, no zeroes
    By vhache in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-24-2018, 09:04 AM
  2. Custom Data Labels does not update with correct labels in a dynamic Scatter XY Plot Graph
    By kujikuru in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  3. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  4. Excel 2007 : Pivot Table Row Labels and Column Labels contain items not in data
    By celiowin in forum Excel General
    Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  5. Excel 2007 : Excel 2007 - Pie Charts - Data Labels - Best Fit - Moving labels next to Legend
    By yellowbooks in forum Excel General
    Replies: 2
    Last Post: 02-17-2011, 02:13 AM
  6. SUBTOTAL formulas stop working correctly when new data is added. How do I stop this?
    By fbarbie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2005, 05:49 PM
  7. [SOLVED] Stop Excel from converting text labels in CSV files to Values
    By Just Want a Label! in forum Excel General
    Replies: 1
    Last Post: 01-11-2005, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1