Charting Weight

[slide]

I'm trying to make a chart that I can track my weight loss progress with. I have setup starting weight, ending weight, starting date and ending dates and have created a chart that shows a line to represent what my weight should be on each day (auto generated using Named formulas) but I can't get my actual weight values to show up properly. Say if I forget a day and then the next day enter my weight, it will show up on the previous day and not where its supposed to.

[Andy Pope]

You will need to plot the actual weights as xy-scatter. As it does not share the current category axis range, which is a named range.

And your expected weight line can also be created as an xy-scatter using the 2 sets of values for start and finish of line.