I'm having trouble with org-plotting data that is captured on certain dates over time, like my bodyweight. My table looks like this, but the plotting seems to be very wrong:
#+PLOT: ind:1 timefmt:"%Y-%m-%d" with:points
| Date | Weight |
|------------+--------|
| 2008-09-26 | 266 |
| 2008-10-08 | 261 |
| 2008-10-16 | 263 |
| 2008-10-19 | 259 |
| 2009-05-20 | 272 |
| 2009-06-12 | 274 |
| 2009-06-23 | 275 |
I've attached the incorrect image.
Also how can I plot the totals from a bunch of separate tables as the dependent variable? Each of the tables would be like the following below:
| Time | Description | Calories |
|------+------------------------+----------|
| 6:00 | Whey shake, 2 scoops | 200 |
| | + 2 cups skim milk | 180 |
| 9:30 | 4 egg whites | 120 |
| | + 2 slices salami | 200 |
| | + 1 slice cheese | 110 |
| | Whey shake, 2 scoops | 200 |
| | + 2 cups skim milk | 180 |
| | light yogurt | 60 |
| | rice cake | 40 |
| | + 2 tbsp peanut butter | 200 |
|------+------------------------+----------|
| | TOTAL | 1490 |
#+TBLFM: @12$3=vsum(@2$3..@11$3)