Avoid drawing blank values

I

ivarela1

Hello,

Can you tell me if there is a way to plot only non-blanked values from
a table:

F.e. if:

X= 1,2,3,4
Y=10, ,10,10 (so no value for x=2)

I want to obtain a continuous line going from the first point (1,10) to
the third point (3,10) and then of course to (4,10).

Thanks in advance for your help,

Iván
 
D

dvt

Can you tell me if there is a way to plot only non-blanked values from
a table:
Click to expand...

If the cell is truly blank, select the chart and from the menu click Tools
| Options | Chart tab | Plot empty cells as... (make your choice).

If the cell contains a formula that returns "", then Excel does not
consider that cell blank. One of the great frustrations in the .charting
newsgroup is that you can not make a cell appear truly blank using
functions. A workaround is to make your function return the #N/A value
using the NA() function rather than "". The chart will ignore that cell..
If you dislike the appearance of the #N/A errors in your sheet, cover them
up with conditional formatting.
 
Top