don't chart na/zero value in area chart

**maacmaac** · 11-27-2010, 02:29 AM

I'm trying create an area chart and I do not want to chart zero values. I've tried using na(), zero value, and null in the data table but nothing seems to work (example attached). Is there any way to not chart this field? Thanks

**zbor** · 11-27-2010, 05:15 AM

#N/A will really do a trick but not for area chart.

Can you use a line chart instead?

**maacmaac** · 11-27-2010, 12:02 PM

tried using the #N/A....it does work for line chart but management wants to see an area chart. Any other suggestions? Thanks

**Maistrye** · 11-28-2010, 04:13 AM

What exactly is management expecting to see for a date such as the monday on the chart?

Off the top of my head, I'd say you could do one of the following two things:

1. Remove the data point.

2. Put in a formula such that the intervening "no data" point represents the average of the points adjacent to it. The intent is so there is a straight-line from the previous point with data to the next point with data.

For example, for the data you provided, cell B9 could have the formula =AVERAGE(B8,B10). If it's possible to have two or more consecutive "no data" points, the formula would need to be slightly different.

S