I'm creating a bunch of charts of measurements.
I am simply charting
X axis: Date
Y axis: measurement
Except the measurements are not equispaced. E.g. there may be one measurement one month, and 4 the next month. So the chart equispaces the values even though that is not correct.
What tricks do people do to equi-space their date charts?
I've come across this a few times before and I usually create another table loaded up with dates and run the chart from that table. Is that my best option??