When I plot these two datasets (values on a primary and secondary Y-axis, dates on X-axis), I can´t seem to independently match the data points to each individual date. You will see that there is an offset between the two dates, as they are from two different counries with different holidays, but when I plot, the second dataset for example automatically plots the value 3.3 on 04/07/2017 instead of 05/07/2017. Any idea how to have each value match its corresponding date on a single chart?
Thanks in advance for any help!
Thanks in advance for any help!
04/07/2017 | 145,500.00 | 05/07/2017 | 3.3 | |
05/07/2017 | 145,500.00 | 06/07/2017 | 3.25 | |
06/07/2017 | 145,500.00 | 07/07/2017 | 3.35 | |
07/07/2017 | 145,500.00 | 10/07/2017 | 3.5 | |
10/07/2017 | 145,500.00 | 11/07/2017 | 3.65 | |
11/07/2017 | 145,500.00 | 12/07/2017 | 3.6 | |
12/07/2017 | 145,500.00 | 13/07/2017 | 3.6 | |
13/07/2017 | 145,500.00 | 14/07/2017 | 3.6 | |
14/07/2017 | 145,500.00 | 17/07/2017 | 3.6 | |
17/07/2017 | 145,500.00 | 18/07/2017 | 3.6 | |
18/07/2017 | 145,500.00 | 19/07/2017 | 3.55 | |
19/07/2017 | 145,500.00 | 20/07/2017 | 3.6 | |
20/07/2017 | 145,500.00 | 21/07/2017 | 3.6 | |
21/07/2017 | 145,500.00 | 24/07/2017 | 3.8 | |
24/07/2017 | 145,500.00 | 25/07/2017 | 4.05 | |
25/07/2017 | 145,500.00 | 26/07/2017 | 3.9 | |
26/07/2017 | 145,500.00 | 27/07/2017 | 3.85 | |
27/07/2017 | 145,500.00 | 28/07/2017 | 3.95 | |
28/07/2017 | 145,500.00 | 31/07/2017 | 4.05 | |