MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Mark W. on February 09, 2002 12:13 PM

=IF(B50,B5,#N/A) [nt]

Posted by Mark W. on February 09, 2002 12:14 PM

=IF(B50,B5,#N/A) [nt]

Posted by Mark W. on February 09, 2002 12:17 PM

=IF(B5<>0,B5,#N/A)

Posted by Mike on February 09, 2002 7:54 PM

Cool, Thanks!