1

I'm doing a weekly log for some athletes with some data and I want to chart it as they fill it in during the week. The only issue is that for days in the week where the data hasn't been entered yet, the formula produces a result of zero, which gets included in the chart, throwing the scatter graph off. How can I get the chart to stop plotting zeros?

Improve this question
2
  • superuser.com/questions/654279/…
    – user387876
    Commented Dec 22, 2014 at 23:35
  • @Tyler - that link covers a different issue (the appearance of labels). This question is about a scatter chart and blank values being plotted as data points with a value of zero.
    – fixer1234
    Commented Dec 23, 2014 at 0:38

1 Answer 1

Reset to default
2

Adjust your formula so that if the input is blank, it returns NA(). Something like this:

=IF(LEN(A2)>0,your-formula-here,NA())

This puts #N/A into the cell, which may look strange, but an XY chart ignores #N/A, without plotting a point. If the chart has lines connecting the markers, the line will pass over where the #N/A point would have gone, connecting the points on either side.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .