Avoid drawing blank values

  • Thread starter Thread starter ivarela1
  • Start date Start date
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
 
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.
 
Back
Top