Elan

Posts: n/a

empty cell

I have a column with formulas.
When formulas return empty cell (""), the chart seems to handle
it as a 0. I do not want to display those data points at all.
I tried to use NA() instead The chart seemed to be o.k but now I have a
problem finding MAX/MIN Values of this column €“ because I have there now both
numbers and #N/A.
Thanks
Elan

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
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
Can I use the contents of a cell to satisfy the result_vector arg.	robh_2	Excel Worksheet Functions	3	February 24th 05 08:14 PM
make a cell empty based on condition	mpierre	Charts and Charting in Excel	2	December 29th 04 01:01 PM
Display a dialog box if cell is empty	jst	Excel Discussion (Misc queries)	2	December 28th 04 11:59 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 04:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us