Chart Data
Posted by Mike on February 08, 2002 7:54 PM
I have a scatter chart that references data indirectly. Each cell in the chart range is a formula:
=if(B5<>0,B5,"")
for example.
The problem is that even though the cells show as empty, they get plotted on the graph as 0. What do I need to do to the formula to make it not plot those points? I tried going into TOOLS, OPTIONS and selecting the chart tab but it is already set to PLOT VISIBLE CELLS ONLY and PLOT EMPTY CELLS AS: NOT PLOTTED.
Thanks