Bernard Liengme Wrote:
1) Click chart to activate it
Use Tools | Options; open Chart tab; specify how empty cells are to be
treated

Actually, I had already set it to not plot empty cells, but it does
anyway. It seems I can't attach an Excel file to this message, but if
you give me your email address I'll send it to you. My email address
is . Thanks.


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=511363

If the cell contains a formula, even one that returns "", it's not blank. It
contains a formula that returns a text item. Follow Bernard's instructions
for using NA().

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

"MattBeckwith"
wrote in message
news:MattBeckwith.232y4b_1139686501.7405@excelforu m-nospam.com...

Bernard Liengme Wrote:
1) Click chart to activate it
Use Tools | Options; open Chart tab; specify how empty cells are to be
treated

Actually, I had already set it to not plot empty cells, but it does
anyway. It seems I can't attach an Excel file to this message, but if
you give me your email address I'll send it to you. My email address
is . Thanks.


--
MattBeckwith

The referenced web page says:

When an empty cell is filled with =NA(), Excel interpolates the missing
data, joining adjacent data points

I don't want the missing data points interpolated.

However, I went ahead and tried the NA() approach, as follows:

=IF('3'!B230,'3'!B23,NA())

But it just filled the cell with

#NA


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=511363

Yes, that is what we want. Now make the chart.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MattBeckwith"
wrote in message
...

The referenced web page says:

When an empty cell is filled with =NA(), Excel interpolates the missing
data, joining adjacent data points

I don't want the missing data points interpolated.

However, I went ahead and tried the NA() approach, as follows:

=IF('3'!B230,'3'!B23,NA())

But it just filled the cell with

#NA


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile:
http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=511363

(Reply made by mistake.)


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=511363

I have followed this thread and I have a particular problem that I
thought it was intended to solve.
I am plotting with dates on the X axis. The Y values are function
determined. Using the IF function I have tried giving the cell a NA
value but the plot then extrapolates between the points. I do not want
to give it a zero value.
But I actually want the gap.
I suppose I could, using a macro, copy the series and then delete any
cells with NA in them and then use this as the basis for the plot.
Is there a way of avoiding this?
Des M


--
DesM
------------------------------------------------------------------------
DesM's Profile: http://www.excelforum.com/member.php...o&userid=24121
View this thread: http://www.excelforum.com/showthread...hreadid=511363

Check Andy Pope's site (http://andypope.info) for a technique to display a
gap for this situation.

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

"DesM" wrote in message
...

I have followed this thread and I have a particular problem that I
thought it was intended to solve.
I am plotting with dates on the X axis. The Y values are function
determined. Using the IF function I have tried giving the cell a NA
value but the plot then extrapolates between the points. I do not want
to give it a zero value.
But I actually want the gap.
I suppose I could, using a macro, copy the series and then delete any
cells with NA in them and then use this as the basis for the plot.
Is there a way of avoiding this?
Des M


--
DesM
------------------------------------------------------------------------
DesM's Profile:
http://www.excelforum.com/member.php...o&userid=24121
View this thread: http://www.excelforum.com/showthread...hreadid=511363