5.7. Visualize pivot table data as a chart or a map

When you have made a pivot table you can switch between pivot table, chart and map visualization of your data.

5.7.1. Open a pivot table as a chart

  1. Click Chart > Open this table as chart.

    Your current pivot table opens as a chart.

5.7.2. Open a pivot table selection as a chart

If you want to visualize a small part of your pivot table as a chart you can click directly on a value in the table instead opening the whole table.

  1. In the pivot table, click a value.

  2. To verify the selection, hold the cursor over Open selection as chart. The highlighted dimension headers in the table indicate what data will be visualized as a chart.

  3. Click Open selection as chart.

5.7.3. Open a pivot table as a map

  1. Click Chart > Open this table as map

    Your current pivot table opens as a map.

5.7.4. Open a pivot table selection as a map

  1. In the pivot table, click a value.

    A menu displays.

  2. Click Open selection as map.

    Your selection opens as a map.