Charts - Value over Time


I am trying to create a chart which displays a contingency fund remaining balance over time. Here is what I was able to produce:

This looks great, but the x-axis(time) is not to scale. I am pulling from a sheet that contains all instances of contingency fund draws, but they will not occur at a regular interval. Is there any way for the chart to adjust the x-axis scale based on date, so I can get a more accurate representation of the fund over time?


Best Answer