Can someone please have a look at the attached demo file and tell me how they have managed to keep the formatting in their pivot table when using the 'zoom in' 'zoom out' buttons.
You will notice that all the totals stay coloured, I thought that this was impossible and am very keen to understand how this works.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…