I have defined a Dynamic Name as follows:

=OFFSET(Sheet1!$A$4,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1)

The label for the data is in A3, the data starts in A5 and continues
downward. The definition above does start plotting from A5 but adds a blank
cell. There is always one extra empty data point that is plotted. Is there
an easy fix so that the plot starts at A5 and stops at the last data point?

Thanks.