Proportionally spread dates on chart x-axis?
I'm trying to do a chart of weight v time for my medical records, but the observation dates are not regular, so my chart is distorted. For example if I have the following seven observation dates:
1/1, 1/2, 1/3, 1/4, 1/5, 1/15, 2/15,
the seven data points appear spread evenly across the x-axis. What I really need is for them to appear with correct chronological spacing. E.g. the first five dates should cluster on the left end of the chart, the 1/15 observation should be in the middle, and the 2/15 observation should be on the right.
I'm using line with markers chart type.
Any suggestions?
Thank you!
- James
|