Nothing straightforward, but Andy Pope has a technique for this:

http://andypope.info/charts/brokenlines.htm

Other alternatives include deleting the cells to form a gap (via macro which
can recreate the formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
Hi RW,

I don't believe there is a straight forward way to do this.

--
Cheers,
Shane Devenshire


"RW" wrote:

I have found the trick to prevent 0's from showing in a chart when the
data
is blank:

If(H2="",NA(),H2/F2)

However, the chart line extrapolates from the previous data point to the
next datapoint instead of showing a gap. I've looked at
Tools-Options-Chart
and the Active Chart - Plot Empty Cells as "Not Plotted (leave gaps)" is
selected.

The data is being charted on a secondary Y axis if this makes a
difference.
Please help. I need to have gaps.