Step by Step - Getting Started Guide

Step 4 – Using the Pivot Table

How to Chart Data

To chart data, when chart is in the view layout:

1. Click  to expand the chart toolbar. To lock the chart toolbar in place, click again.  Select the type of chart by clicking one of the chart icons.  The selected chart type is displayed.
2. To change the range of data charted, click on a grid cell and drag the mouse over the desired range of cells in the grid.  The chart is updated to include the selected range.
3. Panorama automatically selects the best subset of data for the chart. However, if you wish to change the default selection to add or remove specific rows or columns for the chart – hold down the Ctrl key and drag the mouse over the target cells.

Charting Options

The following chart types and options are available by clicking the chart toolbar icons:

- Bar Chart

- Stacked Bar Chart

- Line Chart

- Pie Chart

- Chart Legend Layout Menu

Chart Rotation – chart series can be derived either from grid rows or columns. Use this button to switch between the two.

 

How to Save Your View

On the main toolbar, click . A window appears, displaying "Operation Succeeded".  Click OK.  The view is saved.

Now a saved view can be shared with your colleagues and other Google users using the standard Google Docs sharing and publishing features.

 

<-Previous Step Next Step->

 

 

SaaS BI Overview

Spreadsheet Analysis

Pivot Table Tutorial

Corporate Data Analysis

Analytics for Salesforce