MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,