Page 271 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

The Fields are created based on the backend data used for the Pivot Table. The Areas section is where you place
the fields, and according to where a field goes, your data is updated in the Pivot Table.

It’s a simple drag and drop mechanism, where you can simply drag a field and put it in one of the four areas. As
soon as you do this, it will appear in the Pivot Table in the worksheet.

Note that by default, the items (in this case the customers) are sorted in an alphabetical order.
What is pivot chart?
Pivot Chart is a dynamic visualization tool that works together with Excel PivotTables. While PivotTables provide
a way to summarize and analyze large datasets, Pivot Charts offer a graphical representation of that summarized
data, making trends and patterns easier to spot.

258

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77