I'm creating a tracker for client sales, cumulatively and weekly, so I have the layout with the dates (every friday) whereby I put in the current, year to date total unit sales and from there the table below does =if(j23="","",sum(j23-j22)), hence when no sales figures have been entered then the cell remains blank and when the new cumulative figure has been entered then it automatically puts in the difference between last weeks figure and this weeks.
The problem with this is that when plotting a line chart for the period, any blank cells are shown as 0, rather than just not drawn. I've tried using NA() instead of blank but no joy.
Edited to add: This is Excel 2002.
Edit: Problem solved, see link below.
Bookmarks