Blank fields not being accurately counted on chart

[Richie_m21]

My data has 30 lines, two of which are blank for the column I am graphing. When the graph gets created, the pivot data shows there being zero blanks, and graphs this zero value. I need it to show that there were 2 blank fields.

Please help!Data - 30 lines.JPGChart.JPG

[teylyn]

Can you create a copy of the file, replace all confidential data like names with dummy text and post the file?

[Andy Pope]

See this article.

http://blog.contextures.com/archives...n-source-data/

[Richie_m21]

Thanks Andy. While it isn't all that logical, I can see the reasoning behind it. Much appreciated!