Class Nine ; Text (Pivot Table and Pivot Chart)

TO CREATE A PIVOT TABLE

Click any single cell inside the data set, on the insert table, click pivot tables, a dialogue box will appear and excel will automatically highlight the data for you, the default location for the new pivot table is new worksheet, click Ok.

4 components of pivot table

1.      Filters 2. Columns 3. Rows 4. Values

These are where various field names can be placed to create a pivot table.

The task pane also includes a check list area of the fields from which to choose from the data. Drag one field name into different areas to create a pivot table

.

CHART

Chart are visual representations of data used to make it more understandable.

Commonly used charts are; pie chart, column chart, line chart.

A chart is a visual representation of your data that helps you understand and communicate information more effectively.

With Excel charts, you can turn numbers into insights, revealing trends, patterns, and relationships in your data. Whether you’re tracking sales, analyzing student performance, or monitoring progress towards a goal.

Charts make it easy to:

– Visualize complex data

– Identify key trends and patterns

– Compare data across different categories

– Communicate insights and findings to others

Types of charts

1.      Column chart

1.      Line chart

2.      Bar chart

3.      Area chart

4.      Stock chart

5.      Surface chart

6.      Radar charts

7.      Treemap chart

Create a chart

Click anywhere in the data for which you want to create a chart, select insert charts and pick chart type you want, on the menu that opens, select the option you want.

To edit the chart (titles, legends, data labels) select the chart table show plus sign and then select format.