Page 272 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

How to make a pivot chart in Excel:
Before you start creating a pivot chart, it’s important to make sure your data is well-organized and structured.
Each column should represent a different variable or category, and each row should contain a unique record.
Don’t forget to remove any blank rows or columns and double-check your data for errors or inconsistencies.
Tip. If you want your graph to automatically include new records, then format your source data as a table.
Step 1. Insert a pivot chart

1 Select any cell in your dataset.
2 On the Insert tab, in the Charts group, click PivotChart.

3 The Create PivotChart dialog window will pop up, automatically selecting the entire data range or table. It will
then prompt you to choose where to insert your visual - either in a new worksheet or an existing one. Select
your preferred location and click OK.

259

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