<div>
Think I found a possible one.<br />
<br />
IF(A1 = 0 , #N/A, A1)<br />
<br />
any better ways so I don't have to add another IF in my formula.<br />
<br />
sk
</div>


Think I found a possible one.

IF(A1 = 0 , #N/A, A1)

any better ways so I don't have to add another IF in my formula.

sk

<div>
<div class="content wysiwyg-content">
I have a dynamic XY chart.<br />
<br />
Dates in COL A &nbsp;and the values are in whatever column I offset to. &nbsp; Some values are Zero. &nbsp;I do not want to show the value on the chart as zero if there is no value.<br />
<br />
I have tried using a custom # format.<br />
I have tried using a formula &nbsp;(probably didn't do this one correct)<br />
<br />
How can I do this. &nbsp;I want to show the gap in the line not have it drawn on the X axis as Zero.<br />
<br />
thanks experts.<br />
<br />

</div>
</div>


I have a dynamic XY chart.

Dates in COL A  and the values are in whatever column I offset to.   Some values are Zero.  I do not want to show the value on the chart as zero if there is no value.

I have tried using a custom # format.
I have tried using a formula  (probably didn't do this one correct)

How can I do this.  I want to show the gap in the line not have it drawn on the X axis as Zero.

thanks experts.



Hide zero values on an X Y scatter graph

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.