I have a few pet peeves with Pivots however, mainly being that they require data be in a particular layout that they can be restrictive on the type and layout of the output they produce (although they do provide a good level of options) and when updating or changing data within a spreadsheet Pivoted data does not refresh unless it’s explicitly told to (which can create a jarring experience when handling and presenting larger data sets). Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touch of a button. Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don’t know where to start.
