How to identify the expression column number of pivot chart
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.
Re: How to identify the expression column number of pivot chart
So the index 0 points first dimension. My requirement is to always hide the first expression. For this I am trying to write a macro like this. But When the user changes the number selections in Pivot table the width is interchanging to other columns. Please tell me how to tweak this macro so that it always identifies the first expression.