Can I create an auto update chart in a template
 

I created a template with a chart. The chart needs to update itself
automatically by the number of items in Col B and plot the value in D that
are $$ values in pct. I used an offset in Naming the ranges but will not
reference in the source data in the chart. Is it because the file is a
template??