Apply Styles to PivotTable

In order to make PivotTable reports more readable and visual appealing, there is need to apply style of our choice  from eighty-five (85) built-in styles. This categories in to “Light”, “Medium”, “Dark” plus sixteen (16) combinations of styles options in the PivotTable styles gallery located on the design tab under PivotTable tools. You can go a[…]

Shares 0

How to build an Interactive Chart

The concept of an interactive chart is aim at making Excel dashboard more flexible for users to choose whatever they wanted to see by changing the selection in the drop down menus to drive automatic chart updates in their report. I will show the simplest way to build an interactive chart once. This will allow[…]

Shares 0