I'm trying to create a dynamic chart in Excel, i.e. it updates when more data rows are added. Done the first bit of getting that to work, but now its trying to apply it to my own spreadsheet. How do I count the number of cells in a row that have data in them so I know the range to be plotted. Have tried Count and Counta but they count the cell if it has a formulae in it as its therefore not empty. I need to find out what cells don't have a value in it, wether or not it has a formulae in it.