How to ignore 0 value figure in line chart?

**whoiswct** · 2013-01-06, 10:51 AM

How to ignore 0 value figure in line chart?

I am plotting line chart.
x-axis is month from Jan 2013 to Dec 2013.
y-axis is revenue $.

There is no value in the future months, but the line chart connect the line.
In stead of selecting the data range each month, can I do some setting to ignore the zero value data?

**Andy Pope** · 2013-01-07, 12:34 PM

Use NA() instead of "" in your formula.

**whoiswct** · 2013-01-19, 03:24 AM

Attached a sample.
If I don't want to modified the data range every month, how can I do to have the expected result chart? (i.e. ignore the zero value in the months)