Plotting zero's on graphs

[Paul Watkins]

Hi
I have a sheet setup as Jan-Dec and underneath are values for each month
which are linked to another sheet.
In the graph from that data, it plots all the points (jan to dec) because
the links show as zero's
Is it possible for excel to NOT plot zero's (the links) on the graph ?

Thanks in advance

Paul

 

[Debra Dalgleish]

You can use an IF formula with NA(). For example:

=IF(B2="",NA(),B2)

The chart will interpolate over the #N/A errors. To hide these errors,
you can use conditional formatting.
http://www.contextures.com/xlCondFormat03.html#Errors