I am using excel 2010 to make a chart (X over Y chart with linear regression line). The two colums data I use are both means of two other columns (x1,x2 and y1,y2). There are 50 rows, but not all of them are filled. I use the =ALS(B5="";NA();GEMIDDELDE(B5:C5)) formula to put #NAAM? in het boxes were x1,x2,y1 and y2 are empty, as was suggested by different fora. But I still get an (0,0) point in mij chart. If I use the 'hidden and empty cells' pop I can only select to show them as opening or 0. I can't seem to choose not to plot them.
Some suggestions?
Some suggestions?
