| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
| vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming | |||
| vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming | |||
Threaded Mode
