how to get individual items in a range to change when using slicers

[William53]

Hi All
I have developed a dashboard from a table and have it working ok with slicers and charts but I want to be able to link a particular set of metrics to each company but I am struggling how to do it.

This is a picture of the dashboard - I need the green boxes to change when I click on a company. So if I click Fluor, the green boxes will show how many of each category is attached to each company. Below is a sample, hope this helps

No.

Name

Company

Date

Day

Month

Year

Week

Time

Observation

Poss Consequences

Subject

Obs

Further Action

Action Required

Status

1​

William Wootton (F)

Fluor

01-May-24​

Wed

May

24

18​

10:30​

UA

Injury / Illness

PPE

Worker not wearing glasses - spoken to about site rules

No

Closed

2​

William Wootton (F)

Fluor

14-May-24​

Tue

May

24

20​

11:30​

UC

Injury / Illness

Slip /Trip / Fall

Cable from transformer sitting above the ground

Yes

Lowered cable to the ground and put cones to warn personnel

Closed

 

[iliace]

If the green boxes are shapes, you can link them to cells to display a value (like the Camera tool). Then set up a pivot table in the background somewhere with Observation in row and connect to the company slicer.

To link a cell to a shape, select the shape, and type =$A$1 in the formula bar just like you would in a cell.