+ Reply to Thread
Results 1 to 2 of 2

Hide DIV/o in chart

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Hide DIV/o in chart

    The previously SOLVED thread - http://www.excelforum.com/excel-char...cel-chart.html
    doesn't work if I want to also hide the data that would appear on the X-axis. I am using the formula =IF(ISERROR(Q14*3/G14),NA(),(Q14*3/G14)) on a week by week basis, to hide the DIV/0 results in the y axis, but future dates in the x axis are still appearing. EG today I have a chart with data appearing for weeks ending up to 07/03/14, but on the x axis the future weeks ending 14/3/14 and onward are still appearing with blanks on the y axis
    Attached Files Attached Files

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

    Re: Hide DIV/o in chart

    You need to use named ranges as the series data source in order to exclude #N/A items
    Cheers
    Andy
    www.andypope.info

+ 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. hide a series in a chart
    By Nitzan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-02-2013, 02:18 PM
  2. How to hide 0 chart values?
    By toplisek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2012, 08:02 AM
  3. Display/Hide chart
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2012, 11:29 AM
  4. HIDE ZEROS IN CHART - Hide rows of cells that equals zero
    By sweedey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2011, 08:18 PM
  5. Hide items w/a 0 value in a chart?
    By NUMBnut in forum Excel General
    Replies: 1
    Last Post: 07-06-2006, 12:00 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