Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

(blank) Row Labels in Pivot Table

Latest post Sat, Jan 3 2009 1:17 AM by Mike Alexander. 1 replies.
  • Wed, Dec 31 2008 4:19 PM

    • fmarusic
    • Top 50 Contributor
    • Joined on Wed, Oct 29 2008
    • Posts 20
    • Points 308

    (blank) Row Labels in Pivot Table

    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

    • Post Points: 21
  • Sat, Jan 3 2009 1:17 AM In reply to

    Re: (blank) Row Labels in Pivot Table

    Can you not simply hide the "(blank)" value?  Use the dropdown selector for the appropriate row label field and remove the check next to "(blank)".

    Mike Alexander Microsoft Excel MVP www.datapigtechnologies.com
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.