+ Reply to Thread
Results 1 to 2 of 2

Charts - Do Not Chart Blank Cells In Range

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    washington dc
    MS-Off Ver
    Excel 2007
    Posts
    51

    Charts - Do Not Chart Blank Cells In Range

    Hi -

    I'm trying to set up a project deliverables tracker for a multi-year project. Some deliverables (lines), however, do not have specific dates (column J).

    I can't seem to get this project timeline chart to ignore those deliverables (lines) that do not have a date registered in column J. I only want the chart to chart those lines within the range that have a date in column J.

    Help!

    See attached.

    Jacob
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Charts - Do Not Chart Blank Cells In Range

    So you only need K when J has date?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. Replies: 15
    Last Post: 04-25-2012, 05:21 PM
  2. Advanced filter with blank cells / Dynamic named range with blank cells
    By Jason_2112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2010, 12:06 PM
  3. Line chart - Omitting blank/zero cells in data range
    By rkidday in forum Excel General
    Replies: 1
    Last Post: 01-27-2010, 07:29 AM
  4. [SOLVED] Area charts and blank cells
    By Pat in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2005, 02:05 PM
  5. Blank cells in line charts
    By bluenose in forum Excel General
    Replies: 0
    Last Post: 08-11-2005, 09:54 AM

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