I am trying to create a pivot table which includes columns that have no values in some cells. The resulting pivot table creates a value of (blank) for the those column/field values when using those fields as Row Labels. I want to use the row labels as data labels in a Pivot Chart, but don't want (blank) to be displayed. Obviously there are times when I will want to show the text associated with those fields displayed on my graph. What would be the best approach to remove these (blank) row labels or associate the field text with the Pivot Chart as a data label when needed?
| Analysis |
NON_VIABLE |
|
| Point location |
M128 |
|
| Sampling point |
M128POST_A |
|
|
|
|
| Average of Result |
Column Labels |
|
| Row Labels |
Particles Greater or Equal to 0.5 um |
Particles Greater or Equal to 5.0 um |
| 9/29/2008 14:20 |
|
|
| EAR-93 |
|
| EAR-93 |
0 |
5 |
| EAR-94 |
0 |
5 |
| EAR-94 |
|
| EAR-93 |
0 |
5 |
| EAR-94 |
0 |
5 |
| (blank) |
|
|
| (blank) |
1500 |
0 |
| 9/29/2008 14:20 |
|
|
| EAR-90 |
|
| EAR-90 |
0 |
5 |
| EAR-91 |
0 |
5 |
| EAR-92 |
0 |
5 |
| EAR-91 |
|
| EAR-90 |
0 |
5 |
| EAR-91 |
0 |
5 |
| EAR-92 |
0 |
5 |
| EAR-92 |
|
| EAR-90 |
0 |
5 |
| EAR-91 |
0 |
5 |
| EAR-92 |
0 |
5 |
| (blank) |
|
|
| (blank) |
1500 |
0 |
| 9/29/2008 14:20 |
|
|
| EAR-89 |
|
| EAR-89 |
0 |
5 |
| (blank) |
|
|
| (blank) |
3000 |
0 |