Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
Display Units is not accessible in my Excel Chart | Charts and Charting in Excel | |||
How do I get my Excel time-line column chart to display in color? | Charts and Charting in Excel | |||
How do I put a watermark under cells in excel and make it print? | Excel Worksheet Functions | |||
Excel: Can I display a chart when the mouse is over a cell? | Charts and Charting in Excel |