I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for Microsoft Excel/GoogleDocs/AnyOtherSpreadsheet), and I want to create a visual interpretation of their growth.
- A regular line chart should do this just fine. However the measurements are not taken at regular intervals, for the first two weeks they were measured every day, but later it has been weekly, and there is a christmas break of three weeks. But when I try to make a line chart the distance between each data point is the same
How do I make a line chart with dates in a spread sheet, where the distance between each data point on the x-axis is correct according to the number of days between each measurement?
2: There are three different measurements. Weight in grams, height in centimeters, and head circumference in centimeters. For each date there is a measurement, weight is always measured. But height and head circumference is measured only occationally. And as mentioned they are twins. So six different data streams.
Are there any suggestions to how I can present all the data in one single diagram such that it looks cool, but also is easy to understand?
3: Sample data:
DATE | 13.oct | 15.oct | 22.oct | 24.oct | 10.nov | 16.dec | 11.jan
Tinus weight | 2360 g | 2165 g | 2250 g | 2305 g | 2930 g | 4295 g | 5170 g
Adiran weight | 2340 g | 2185 g | 2270 g | 2305 g | 3055 g | 4555 g | 5380 g
Tinus height | 45 cm | | 45 cm | 48 cm | | 55 cm | 57 cm
Adrian height | 44 cm | | 44 cm | 48 cm | | 55 cm | 58 cm
Tinus head | 33 cm | | 33 cm | 34 cm | | 38 cm | 38 cm
Adrian head | 33 cm | | 33 cm | 34 cm | | 38 cm | 39 cm