leeksleeks
Board Regular
- Joined
- Oct 31, 2013
- Messages
- 96
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.
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 |