6.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.

6.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.

6.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 .

6.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.

6.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.