Removing #N/A from an "If/Then" statement
Hi Collin,
Am Thu, 9 May 2013 08:37:03 -0700 (PDT) schrieb Collin Ulvund:
The previous two formulas have been helpful, but unfortunately within my graphs, the formulas send the line to the baseline of the chart, making the chart look incorrect. Is there any way that this could be achieved without a placeholder within the table?
select your diagram = Diagram tools = Select data = Settings for
hidden data or null values = Connect data points with line
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|