Hello everyone,
I'm having a lot of trouble making a graph on what I want on Excel, decided to come here for advice.
This graph is what I have at the moment, although is not what I want.
On the horizontal axis I want the days of the month (which is correct on this graphic) but then on the vertical axis I want it to return the last value of the correspondent day.
For example:
On this case, 01/01/21 it would have to register on the first day of the graph 0.14% (last column) instead of showing all the results before individually (0.24% on the 1st of January, 0.13% on the 2nd of January, 0,02 on the 3rd and so on).
It would have to show on the 2nd of January 0,10%. Maintain the line straight at 0,10% until a new change, which was 08/01 and then change it to -0.02%.
Any help would be appreciated. Thanks.
I'm having a lot of trouble making a graph on what I want on Excel, decided to come here for advice.
This graph is what I have at the moment, although is not what I want.
On the horizontal axis I want the days of the month (which is correct on this graphic) but then on the vertical axis I want it to return the last value of the correspondent day.
For example:
01/01/21 | ATP | Adrian Andreev | Lukas Klein | Hard | 1º Set - Lay the Single Break | Yes | 1.53 | £5.00 | £2.36 | 23.60% | 0.24% | £ 1,002.36 | 0.24% |
01/01/21 | ATP | Adrian Andreev | Lukas Klein | Hard | 2º Set - Lay 1st Set Winner | No | 1.30 | £5.00 | -£1.09 | -10.90% | -0.11% | £ 1,001.27 | 0.13% |
01/01/21 | ATP | Adrian Andreev | Lukas Klein | Hard | 2º Set - Lay 1st Set Winner - Comparison | No | 1.30 | £5.00 | -£1.09 | -10.90% | -0.11% | £ 1,000.18 | 0.02% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 1º Set - Lay the Single Break | Yes | 1.34 | £5.00 | £0.20 | 2.00% | 0.02% | £ 1,000.38 | 0.04% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 1º Set - Lay the Single Break - Comparison | Yes | 1.34 | £5.00 | £0.20 | 2.00% | 0.02% | £ 1,000.58 | 0.06% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 1º Set - Lay the Single Break | Yes | 1.37 | £5.00 | £1.09 | 10.90% | 0.11% | £ 1,001.67 | 0.17% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 1º Set - Lay the Single Break - Comparison | Yes | 1.37 | £5.00 | £1.09 | 10.90% | 0.11% | £ 1,002.76 | 0.28% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 1º Set - Lay the Single Break | No | 1.46 | £5.00 | -£0.89 | -8.90% | -0.09% | £ 1,001.87 | 0.19% |
01/01/21 | ATP | Vitaliy Sachko | Michael Vrbensky | Hard | 2º Set - Lay Set & Break - Comparison | No | 1.15 | £2.50 | -£0.45 | -4.50% | -0.05% | £ 1,001.42 | 0.14% |
02/01/21 | ATP | Altug Celikbilek | Kacper Zuk | Hard | 2º Set - Lay 1st Set Winner | No | 1.48 | £2.50 | -£0.42 | -4.20% | -0.04% | £ 1,001.00 | 0.10% |
08/01/21 | ATP | Adrian Andreev | Marsel Ilhan | Hard | 1º Set - Lay the Single Break - Comparison | No | 1.15 | £5.00 | -£1.20 | -12.00% | -0.12% | £ 999.80 | -0.02% |
On this case, 01/01/21 it would have to register on the first day of the graph 0.14% (last column) instead of showing all the results before individually (0.24% on the 1st of January, 0.13% on the 2nd of January, 0,02 on the 3rd and so on).
It would have to show on the 2nd of January 0,10%. Maintain the line straight at 0,10% until a new change, which was 08/01 and then change it to -0.02%.
Any help would be appreciated. Thanks.
Last edited: