Results 1 to 3 of 3

Thread: How to disable excel for taking empty cell in Excel chart

  1. #1
    Join Date
    Jan 2011
    Posts
    22

    How to disable excel for taking empty cell in Excel chart

    I am trying to create several charts from my excel data. Several of the chart's reference cell (established range) contains formulas. When the cell's formula returns a null value, chart display's as zero. How do I setup chart to display null as nothing versus zero.

  2. #2
    Join Date
    Jul 2011
    Posts
    634

    Re: How to disable excel for taking empty cell in Excel chart

    The workaround for charting calculated cells when you may have missing data is to use an If formula that selects NA() if there is missing data. Something like = If( d2 = "", NA(), b2*d2). You'll need to replace your actual cell references and formula. This formula will place a #N/A in those cells that can not be calculated because of your missing data. Excel recognizes #N/A cells in charting and ignores them.

  3. #3
    Join Date
    Jul 2011
    Posts
    640

    Re: How to disable excel for taking empty cell in Excel chart

    Try: Go to menu Tools>Options>Active Chart, Plot Empty Cells as. This only works for blank cells, not if a formula returns a zero-length string.

Similar Threads

  1. How to get rid of empty space at start of Excel Cell
    By AdilShaikh18 in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:29 PM
  2. Replies: 4
    Last Post: 25-01-2012, 12:05 PM
  3. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  4. Replies: 2
    Last Post: 04-01-2012, 06:54 PM
  5. Excel Function and Excel Chart Colors
    By Samarth in forum Windows Software
    Replies: 5
    Last Post: 13-01-2010, 08:16 PM

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
  •  
Page generated in 1,711,666,209.10475 seconds with 17 queries