I have a spreadsheet that I use to track the scores and averages of the members of my bowling team. The most useful number on this sheet is the average for the season, which determines each bowler's handicap. I've got the spreadsheet calculating the average correctly, and it leaves the cell blank if the bowler was absent on any given week (missed games don't affect the average).
Then I went and created a chart to display all four team member's averages over the course of the season. The blank averages presented me with two problems (well, the same problem, but I suspect two different answers): the blank cells get charted as zeros, which looks really bad on the chart.
So, how do I get the chart to not plot those datapoints that are blank? I would want (if at all possible) for the blank gaps to be not plotted, with the chart connecting the points on either side of the gap. Secondly, I would want the chart to just end with the most recent week we've bowled, and not show a line that goes until the end of the season.
I did try changing the cell formula so that it would put the previous week's average, rather than blank, if the bowler was absent, and this was better than having them plot as zeros, but not much.