3 Replies Latest reply: Aug 18, 2015 6:12 PM by sam parker RSS

    How to identify the expression column number of pivot chart

      Hi Friends

       

      I am trying to hide first expression column in my pivot chart using the following macro  code. But how to call this macro to hide the first expression column in pivot char. Is it N or N-1 or something else.

       

      Public Sub hide

      Call HideColumn("CH67",2)

      Call HideColumn("CH69",2)

      End Sub

       

       

      Private Sub HideColumn(ch,n)

         Set ch = activeDocument.getsheetobject(ch)

               ch.setpixwidth(n),0

         End Sub

       

      Thanks