Connecting one slicer to several pivot charts

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which setting links one slicer to several pivot tables?

A Report Connections

B Report Cleaning

2. To connect a slicer to a second pivot table, what do you do in the Report Connections box?

A Tick the box next to that pivot table

B Retype the pivot table's name into the slicer

3. Two pivot tables are built from the same source data. Can one slicer control both?

A No, each pivot table needs its own slicer

B Yes, using Report Connections

4. Pivot table A uses the 'Sales' table and pivot table B uses a different table called 'Staff'. What happens in Report Connections?

A Pivot table B is not offered as an option to connect

B Both are listed and can be connected

5. You tick three pivot tables in Report Connections and then click 'Year 9' on the slicer. What happens?

A Only the first pivot table updates

B All three pivot tables and their charts update at once

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Report Connections		AThe pivot tables have different source data, so the second one will not appear in Report Connections. Build both from the same source data.
2Tick the box beside each pivot table		BOnly one pivot table is ticked, so the other pivot chart will not change when the slicer is clicked. Tick every pivot table you want to link.
3To link a slicer to more than one pivot table, right-click the slicer and open this option.		CReport Connections...
4Pivot tables can only share a slicer when they are built from the same source data, such as one table.		DConnects that pivot table to the slicer, so it filters whenever the slicer is clicked.
5Report Connections: only PivotTable1 is ticked		EThe slicer setting that lets one slicer control several pivot tables, so one click updates all the linked pivot charts.
6PivotTable1 uses SalesTable, PivotTable2 uses a different data set		FSource: SalesTable (for both pivots)

Definitions

Report Connections

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Right-click slicer > __________________

Report Connections: tick each __________

Pivot tables need the ____ source data

One ______ can update many pivot charts

One click updates every ______ chart

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Select a pivot table cell

B Open Report Connections

C Tick each pivot table

D Click OK

Question 2

A PivotTable1 uses Sales

B PivotTable2 uses Sales

C Each uses a different source

D So one slicer can link both

Question 3

A Click the slicer

B Open Slicer Settings

C Tick PivotTable1 and 2

D Click OK

Question 4

A Make PivotTable1 and 2

B Insert a slicer for Region

C Open Report Connections

D Leave PivotTable2 unticked

E Click OK

Question 5

A Build one pivot table first

B Insert one slicer

C Open Report Connections

D Tick both and click OK

Answer Key

Connecting one slicer to several pivot charts

Section A: Quick Questions

A — Report Connections

A — Tick the box next to that pivot table

B — Yes, using Report Connections

A — Pivot table B is not offered as an option to connect

B — All three pivot tables and their charts update at once

Section B: Match the Pairs

Report Connections → The slicer setting that lets one slicer control several pivot tables, so one click updates all the linked pivot charts.

Tick the box beside each pivot table → Connects that pivot table to the slicer, so it filters whenever the slicer is clicked.

To link a slicer to more than one pivot table, right-click the slicer and open this option. → Report Connections...

Pivot tables can only share a slicer when they are built from the same source data, such as one table. → Source: SalesTable (for both pivots)

Report Connections: only PivotTable1 is ticked → Only one pivot table is ticked, so the other pivot chart will not change when the slicer is clicked. Tick every pivot table you want to link.

PivotTable1 uses SalesTable, PivotTable2 uses a different data set → The pivot tables have different source data, so the second one will not appear in Report Connections. Build both from the same source data.

Section C: Definitions

Report Connections — A slicer setting that links one slicer to many pivot tables. Tick each pivot table to connect; they must share the same source data. One click then updates every linked chart.

Section D: Fill in the Blanks

Right-click slicer > Report Connections

Report Connections: tick each PivotTable

Pivot tables need the same source data

One slicer can update many pivot charts

One click updates every linked chart

Section E: Spot the Error

A — Report Connections is opened from the slicer, so you must select the slicer first. It should be 'Select the Region slicer'.

C — A slicer can only link pivot tables that share the same source data. Line 3 should say they share the same source.

B — Slicer Settings only changes the name and sort order. The link to other pivot tables is made in Report Connections.

D — A pivot table is only connected if you tick it. PivotTable2 must be ticked so the slicer controls it too.

A — You need at least two pivot tables to link them. Both pivot tables must exist before you connect the slicer.