beautypg.com

Starting the pivottable wizard, Selecting the data source – Rockwell Automation 9301 Series RSView32 Users Guide User Manual

Page 582

background image

16–20

RSView32 User’s Guide

Once you have created the pivot table, you can then display the data in
a chart. This additional step is also described.

Starting the PivotTable Wizard

1.

Open Microsoft Excel.

2.

On the Data menu, click PivotTable Report.

If you did not install the Microsoft Office Data Access
components, the PivotTable Report item cannot be selected from
the Data menu in Excel.

The PivotTable Wizard appears.

Selecting the data source

1.

In the PivotTable Wizard, click External Data Source, and then
click Next.

Step 2 of the PivotTable Wizard appears.