Excel in Column drawing and pie-shaped graph, numerical display is not empty, or 0 items

For example, there are 10 projects, of which 5 is empty, this rendering of the graphics show only 5 projects.

Simple
First of all, insert – the name – the definition – you need to select the data – the definition of the name (for example, the name of the definition of AA, quoting the regional = Sheet1! $ A $ 1:$ A $ 7, Sheet1! $ A $ 13:$ A $ 14)
Then insert – chart – data = AA, to the normal operation of the other.
In addition, the selection of non-zero and non-air cell can refer to location selection (Ctrl + G) The easiest way is to select the data Region, screening –
automatic selection of non-air (for space) is not equal to 0 (for 0), of course, shows that only 5 ah ah no data