I am using pivot table wizard to create table and chart. I have some cells
that have no data in them and the pivot table is grouping them in a column
labeled blank and charting them on my column chart and putting them in my
chart legend. How can I prevent the blank from showing or being plotted?

Any help would be greatly appreciated.

Worksheet Data
Job # Defect
1 Broken
2 Dropped
3 Torn
4
5 Torn
6 Torn
7

Wizard for Pivot Table Creates the following Worksheet
Defect
Job # Broken Dropped Torn (blank) Grand Total
1 1
1
2 1
1
3 1
1
4
5 1
1
6 1
7
(blank)
(blank) Total
Grand Total 1 1 3 5
--
RCAT1