software

I'm trying to create several charts from my excel data. Several of the
chart's reference cell (established range) contains formuals. 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?


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 = quot;quot;, 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.

I have a tutorial and sample file on this that may be helpful.

processtrends.com/pg_charts_missing_data.htm

....Kelly

quot;Abe-airquot; gt; wrote in message
...
gt; I'm trying to create several charts from my excel data. Several of the
gt; chart's reference cell (established range) contains formuals. When the
gt; cell's formula returns a null value, chart display's as zero. How do I
gt; setup
gt; chart to display null as nothing versus zero?
Try:
Go to menu Toolsgt;Optionsgt;Active Chart, Plot Empty Cells as ...

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

=================================
quot;Abe-airquot; gt; wrote in message
...
gt; I'm trying to create several charts from my excel data. Several of the
gt; chart's reference cell (established range) contains formuals. When the
gt; cell's formula returns a null value, chart display's as zero. How do I
gt; setup
gt; chart to display null as nothing versus zero?
This only works for blank cells, not if a formula returns a zero-length
string. Kelly's suggestion covers this case.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Daniel CHENquot; gt; wrote in message
...
gt; Try:
gt; Go to menu Toolsgt;Optionsgt;Active Chart, Plot Empty Cells as ...
gt;
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt;
gt; =================================
gt; quot;Abe-airquot; gt; wrote in message
gt; ...
gt;gt; I'm trying to create several charts from my excel data. Several of the
gt;gt; chart's reference cell (established range) contains formuals. When the
gt;gt; cell's formula returns a null value, chart display's as zero. How do I
gt;gt; setup
gt;gt; chart to display null as nothing versus zero?
gt;
gt;