+ Reply to Thread
Results 1 to 7 of 7

Ignoring Null Values when Plotting an Excel 2003 Bar Chart

Hybrid View

  1. #1
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Ignoring Null Values when Plotting an Excel 2003 Bar Chart

    Hi molson,

    A similar question recently came up. See post number 4 in:
    http://www.excelforum.com/excel-char...ml#post3552155

    The macro may point you in the correct direction solve your problem. That post was for line charts, however. If you can post a sample workbook, we may be able to better solve your problem.

    Lewis
    Last edited by LJMetzger; 01-21-2014 at 12:53 PM. Reason: Added line chart note.

  2. #2
    Registered User
    Join Date
    08-30-2012
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Ignoring Null Values when Plotting an Excel 2003 Bar Chart

    Hello -

    Here is a sample workbook that I'm working from.
    I'm not very familiar with macro's.

    Excel Forum Charting Help.xls

+ 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. Chart plotting null data
    By treva26 in forum Excel General
    Replies: 2
    Last Post: 06-09-2010, 08:07 PM
  2. Plotting Null Values
    By solnajeff in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-09-2007, 05:16 PM
  3. [SOLVED] Chart ignoring formulas but only plotting formula results
    By JD in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2006, 03:35 PM
  4. Excel 2003 xy chart - problem plotting more than 330 points
    By ehmcneill in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2005, 08:25 PM
  5. [SOLVED] 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