I'm trying to construct a template that does some data analysis and plots the
results, and I am only one step away from getting what I need. The issue is
that the length of my source data table varies for each data set I analyze.
I have the charts made up, but as it is now I must manually change the source
data range each time I use the template. Ideally, I would like to enter the
source data range with a function like INDIRECT (because I can generate the
range as text in the spreadsheet). The Source Data window won't accept this,
however. Is there some other way to do this? Thanks.