Results 1 to 9 of 9

Ignoring Zero Values in Excel Graph

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Lightbulb Ignoring Zero Values in Excel Graph

    Dear Experts,

    I have here attached an excel file for your kind attention and help.

    In this report there is an excel graph whose name is "Quality Index Chart May 2016". The data range for this is in "May 2016 Data sheet". My requirement is; "the CURVES should not drop down to "zero" values although the data sheet contains zero values in the range.

    Thanks in advance.

    Anuruddha
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data Cleanup - ignoring blanks, ignoring rows with string values etc.
    By Huyaku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 08:17 AM
  2. [SOLVED] Ignoring Null Values when Plotting an Excel 2003 Bar Chart
    By molson1973 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-18-2014, 06:11 AM
  3. Replies: 5
    Last Post: 12-04-2013, 04:54 AM
  4. Ignoring zero values on graph
    By FortuneSyn in forum Excel General
    Replies: 8
    Last Post: 02-19-2010, 12:13 PM
  5. Ignoring Zero in Bar Graph
    By shartley in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-21-2008, 05:28 AM
  6. Linking and Ignoring in Excel Graph
    By wesleyslaughter in forum Excel General
    Replies: 15
    Last Post: 01-08-2007, 07:31 PM
  7. ignoring null values in graph
    By Kris B in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2005, 03:05 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