Hi guys,
This one should be an easy one for you out there, but I just couldn't quite figure out.
The problem with the data is that the data points reduced to only 2 per month after April. So if I plot this on a line chart, the X-axis will have unequal spacing towards the end, it will be very crowded.
I was thinking of smoothing the data or interpolating it. But since this is financial pricing data, we want the realistic picture of it. Smoothing doesn't reflect the realistic performance of this financial product.
My question is: Is there a way to make the X-axis equally spaced?
Thank you.
dates x axis.PNG
I have a set of financial data sample with dates that looks like this:
Bookmarks