How to make Excel Chart not to display empty cells?

Posted to microsoft.public.excel.charting,microsoft.public.excel.misc

Marko Pinteric

Posts: n/a

How to make Excel Chart not to display empty cells?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:04 PM.

Menu

About Us