Progressive score chart issue

[neil40]

Hi

I have a chart that has progressive scores for competitors through a season.
So, if they scored 25, 25, 18, 10 for the first 4 of 20 rounds the progressive score is 25, 50, 68, 78

My issue is that in the line chart of this data, the lines drop to zero for the all the rounds not yet competed

Can I prevent this?
Formula's I've used for
First round =IF(E$33="Y",IF(CB3="",NA(),SUMIFS(CB$3:CB$27,B$3:B$27,BD3)),CB3)
Subsequent rounds =IF(F$33="Y",IF(BE3="",NA(),SUMIFS(CC$3:CC$27,$B$3:$B$27,$BD3)+BE3),"")

The first part checking for a "Y" checks to see if the round is complete. The Y is generated if the sum of points for the round equals 101
Perhaps I can eliminate that part somehow

Thanks
Neil

[rcm]

please send a sample workbook

[neil40]

please send a sample workbook

Here is my example sheet

[rcm]

One more question>

Do you want to adjust the graph to only raced competitions, or you want to show the cumulative scores ?

[neil40]

Are they not the same thing?
The graph on the sheet is how it should be, showing cumulative score for all raced competitions thus far.
So when the next race is complete the chart adjusts.

I just don't want the lines to drop to zero.

The chart is showing zero for all competitors for the competitions not yet raced

[MrShorty]

I suggest this essay: http://peltiertech.com/mind-the-gap-...g-empty-cells/ The key thing to learn is that Excel charts treat strings (including empty string "") as the value 0. A better choice when you want a line chart to ignore a point is to use NA() instead of "".

[neil40]

Thanks.

NA() resolved the issue