LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
Andy Pope
 
Posts: n/a
Default How to make Excel Chart not to display empty cells?

Hi,

For more info on the subject have a look at.
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy
Marko Pinteric wrote:
Kelly O'Day wrote:

Marko:

In your If statement, replace "" with Na(). Excel will place a #N/A in
the cells that were getting the "". Excel charting recognizes #N/A
and will not go to 0.


See this post for more details.
http://processtrends.com/pg_charts_missing_data.htm

..Kelly



"Marko Pinteric" wrote in message
...

I have a range of IF formulas. Sometime IF returns number, sometimes
"". The problem is that chart displays "" as value 0. Is there a way
to force chart not to display those empty values?

IF(condition; number_value; "")

Marko







That works, but only partially.

I have such case

<number1
<number2
<number3
#N/A
#N/A
#N/A
<number4
<number5

and then <number3 and <number4 get connected. I want that space
between <number3 and <number4 is empty.

Marko


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make a Chart data series treat blanks as "Empty" cells XLADLK Charts and Charting in Excel 12 June 9th 08 10:53 PM
Display Units is not accessible in my Excel Chart Michele Charts and Charting in Excel 1 January 23rd 06 05:35 PM
How do I get my Excel time-line column chart to display in color? Father Garrin Charts and Charting in Excel 3 July 9th 05 03:56 PM
How do I put a watermark under cells in excel and make it print? Watermarks Excel Worksheet Functions 1 July 1st 05 05:49 PM
Excel: Can I display a chart when the mouse is over a cell? F Schmitt Charts and Charting in Excel 1 June 26th 05 02:49 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"