Just thought of this, but if possible I'd like the chart titles, etc., to be
read from the spreadsheet, too, if there is a way. Thanks!

"Nick H" wrote:

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.