Plotting zero values on a chart
Posted by Duane Kennerson on November 17, 2000 8:11 PM
I have a chart in my workbook that plots values based on a link on the worksheet.
If there is no value in the link, the chart will put a dot on 0 on the X axis.
I used the solution on putting "NA()" instead of "" in an IF clause to get rid
of the dot on 0. Now the problem is how do I get rid of the #N/A that is displayed
instead of a number. Is there some way I can change the font color in the IF formula
when it displays "#N/A" and then change the font color back if it is a normal number???
I tried to do it using VBA on worksheet activate but I kept getting a type mismatch
error when I activated the sheet. Is this confusing? I hope not. Can anyone help???
Thanks in advance.