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”

Use the Field List to arrange fields in a PivotTable

Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. After you produce a PivotTable, you’ll notice the Field List. You can modify the design of the PivotTable by inserting and organising its fields. If you want to sort or filter the columns of data displayed in the PivotTable, see Sort data inContinue reading “Use the Field List to arrange fields in a PivotTable”