Drop downs and graphs

[GJW1971]

First time poster so go easy!

I have multiple tables of raw data over different timeframes that I would like to be able to present as graphs, and to use drop downs so different people are able to pick and choose timeframes / datasets, according to their needs. Example data below, but I have this data summarised by quarter and by year too. Is this possible, and if so, how do I do it?

BY MONTH

Jan-23​

Feb-23​

Mar-23​

Apr-23​

May-23​

Jun-23​

Jul-23​

Aug-23​

Sep-23​

Oct-23​

Nov-23​

Dec-23​

Jan-24​

Total requests tracked

10​

5​

28​

27​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Acknowledgments - Overdue

3​

2​

11​

2​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Acknowledgments - on time

3​

-​

7​

11​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Acknowledgments - average working days

16.0​

217.0​

9.0​

2.6​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Completions - overdue

2​

1​

5​

2​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Completions - on time

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Completions - average working days

43.5​

47.0​

14.0​

6.5​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Request type

Assurance

-​

-​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Best practice nomination

-​

-​

-​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Business case review

1​

-​

2​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Capability assessment

-​

-​

-​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Change control

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Design review

7​

5​

20​

21​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Design surgery

1​

-​

2​

2​

-​

-​

-​

-​

-​

-​

-​

-​

-​

FOI request

-​

-​

-​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Inspection

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Policy review

-​

-​

2​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Training

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

Unknown – more information required

-​

-​

1​

-​

-​

-​

-​

-​

-​

-​

-​

-​

-​

 

[Tivakaran]

You'll need a helper column that you need to use VLOOKUP (or something - i just give idea here) then use the helper column to create graph....so whenever the dropdown is selected, the helper will run & the graph will changed too