Create a PivotChart

Sometimes visualising the big picture can be difficult when your raw data hasn’t been collated. Your first action could be to create a PivotTable, but some people prefer other ways to decipher the meaning of numbers and their associated data. PivotCharts are an easy way to insert data visualisations to your data. Household expense data CorrespondingContinue reading “Create a PivotChart”

Filter data in a PivotTable

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac. Filter your data to hone in on a smaller segment of your PivotTable data for granular analysis. Initially, add one or multiple slicers for a fast and productive way toContinue reading “Filter data in a PivotTable”

Group or ungroup data in a PivotTable

Grouping data in a PivotTable can assist you with displaying a subset of data to analyse. For instance, you might want to group a monumental list of dates or times (date and time fields in the PivotTable) into quarters and months, similar to this image. Note: The time grouping feature is new in Excel 2016. WithContinue reading “Group or ungroup data in a PivotTable”