View Single Post
 
Old 06-07-2015, 01:04 PM
jhoby jhoby is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Posts: 1
jhoby is on a distinguished road
Default 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
Reply With Quote