So I have a spreadsheet that is used to track the Weight and measurements for myself in regards to my workout regimen, to track my weight loss progress.
This is a generalization of how I have things set up and what it would look like with the gap
[TABLE="width: 500"]
Start
[/td]1/1/2016
[/td]300
[/td]Week 2
[/td]1/8/2016
[/td]295
[/td]Week 3
1/15/2016
[/td]Week 4
[/td]1/22/2016
[/td]290
[/td]Week 5
[/td]1/29/2016
[/td]292
[/td]
[/TABLE]
I have defined a dynamic range for Weight with the following formula.
=OFFSET(Measurements!$C$10,0,0,COUNTA(Measurements!$C$9:$C784))
I typically weigh myself every week, but occasionally I miss a week.
When I go to chart this data I get a gap in the chart where the blank is, the chart adds the other points but does not continue the line past the blank.
Any help in creating a dynamic range that can be charted without gaps would be appreciated.
Thanks