Format a line graph so zero values are omitted
Posted by CAS on August 08, 2001 12:23 PM
I have a line graph that is plotting data from June 2001 through the rest of the year. I want to add a trend line to it but from today on, all of my data points are zeroes so my trend line is skewed by these points. I have tried using if statements to make these points blank or spaces but nothing works. Any Ideas? Thanks
Posted by Barrie Davidson on August 08, 2001 12:32 PM
In your IF statement use the NA function instead of returning a blank or space. For example,
=IF(A1<>0,A1,NA())
Regards,
Barrie
