Time based graph

[leeksleeks]

Hi,

Is it possible to create a time based graph in Excel where I can plot a bookmakers odds against the Timestamp (Timevalid) on the axis and the odds on the y axis? I would like to define which Bookmakers to include in a filter for the graph (is this a pivot graph?) as well as which selection (BetHome, BetDraw and BetAway) I want to see. Ideally this would be a scatter type graph with the data points all linked with different colors for each Bookmaker if they are included in the filter. Any help here would be greatly appreciated.

Bookmaker name	BETHOME	BETDRAW	BETAWAY	TIMEVALID
Bookmaker1	2.2	3.95	2.9	09/02/2022 05:44
Bookmaker3	2.2	3.9	2.85	09/02/2022 05:47
Bookmaker5	2.29	4.02	3.024	09/02/2022 05:54
Bookmaker1	2.15	4.3	2.85	09/02/2022 08:25
Bookmaker5	2.216	4.52	2.908	09/02/2022 08:35
Bookmaker5	2.28	4.52	2.805	09/02/2022 08:49
Bookmaker2	2.15	4	2.8	09/02/2022 11:34
Bookmaker4	2.205	4.185	2.878	09/02/2022 11:34
Bookmaker2	2.15	3.95	2.8	09/02/2022 11:35
Bookmaker4	2.211	4.14	2.889	10/02/2022 11:26