I am trying to create a dashboard graph in Excel from a single column with dates, N/A and blanks, like this:
- Date Submitted to Planning
- 20/11/2015
- 20/11/2015
- 13/11/2015
- {blank}
- N/A
- {blank}
- {blank}
- 17/11/2015
- 19/11/2015
- 22/11/2015
What I want to show is number submitted i.e. out of the 9 rows, 6 have been submitted as a doughnut graph (or similar).
I can count the rows for the total number but I'm struggling with how to count the dates and display the results in a format that doesn't just show 1 to 9.