Can we hide a Expression Column

[#1]

Hi Friends,

I am trying to hide the first column of expressions in pivot chart by using the following macro. But when we reload data again its hiding other column which now takes fist index. Can we tweak the macro so that it always hides the first expression irrespective of selections in pivot chat??

Public Sub hide

Call HideColumn("CH67",1)

End Sub

Private Sub HideColumn(ch,n)

   Set ch = activeDocument.getsheetobject(ch)

         ch.setpixwidth(n),0

   End Sub

Thanks

[Anonymous]

You can hide the expressions without using a macro. Go to the expression tab. Check the conditional option and give the condition for which you want to hide it.

[awhitfield]

Hi Pavan,

On the Presentation Tab, select the expression and then click 'Hide' Column'

Regards

Andy