Small problem with a line chart

  • Thread starter Thread starter Neil G
  • Start date Start date
N

Neil G

Hi

I have a smal problem with a line chart.

The chart shows progress of my teams league points over a season, the data
is derived from a series of rows which I fill in after a game.
In the data, I am using COUNTBLANK to have a blank cell until the row
contains data
EG =IF(COUNTBLANK(P53:Y53)>0,"",((P53+U53)*3)+Q53+V53)

The problem is that the data series assumes unfilled rows (IE the future
unplayed games) are zero, so there is a line that connects from the top of
my line down to the zero on my X axis.
I would just like the line to stop at the last value.
Can anyone suggest a way around this please.

Thanks
Neil
 
Instead of an empty string "", use the NA function:

=IF(COUNTBLANK(P53:Y53)>0,NA(),((P53+U53)*3)+Q53+V53)

The chart will interpolate over the #N/A errors. To hide these errors
 
Back
Top