Pivot Charts.xlsx
hi i have inserted a sample file where i get macros to do automatic pivot table number formatting. The macro is turned on by right clicking on a pivot table field and selecting the toggle button. Now when you insert new fields the number formats get applied automatically. The macro uses the number format from the first row.
I use different formats in the same column and was wondering if it was possible to manipulate the code with a lookup and count function to display different formats in the same pivot field.
hi i have inserted a sample file where i get macros to do automatic pivot table number formatting. The macro is turned on by right clicking on a pivot table field and selecting the toggle button. Now when you insert new fields the number formats get applied automatically. The macro uses the number format from the first row.
I use different formats in the same column and was wondering if it was possible to manipulate the code with a lookup and count function to display different formats in the same pivot field.
Last edited: