So I have a weight and measurement tracking excel sheet so that I can track my progress with my current workout program.
I have created a Dynamic Named Range for each of the various measurement areas that I am tracking and have input them into several charts. Everything is working fine, until I skip getting measurements every week and there is a gap in the data and a gap in the chart.
I have attached a screenshot of the chart. I do weekly weigh ins but there are times when I miss it because of work or travel. Is there a way to make the chart display a line between the gapped data.
The Dynamic Ranges were created using the offset command to define the range.
I have created a Dynamic Named Range for each of the various measurement areas that I am tracking and have input them into several charts. Everything is working fine, until I skip getting measurements every week and there is a gap in the data and a gap in the chart.
I have attached a screenshot of the chart. I do weekly weigh ins but there are times when I miss it because of work or travel. Is there a way to make the chart display a line between the gapped data.
The Dynamic Ranges were created using the offset command to define the range.