Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
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
=IF(B50,B5,#N/A) [nt]
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
Re: Chart Data
Posted by Mark W. on February 09, 2002 12:17 PM
Re: Chart Data
Posted by Mike on February 09, 2002 7:54 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.