Stop displaying a line

[Guest]

I have a line graph/chart and it gets its values using a formula and the values of another column. However this poses a problem because if there is nothing in the targetted column the formula returns 0 cause the line to drop to the bottom, instead of casuing the line to just end until a value is added to the target column. How can I do this?

 

[Debra Dalgleish]

Change your formula to use NA() if the cell is empty. For example:

=IF(A1="",NA(),A1)

To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions here:

http://www.contextures.com/xlCondFormat03.html#Errors