Yes, make a so-called "dynamic named range" with OFFSET, see for instance
http://www.cpearson.com/excel/named.htm
http://www.contextures.com/xlNames01.html#Dynamic
GL,
Henk
"pokdbz" wrote:
I have a chart now with this in the data range:
=PHQChartQuery!$A$2:$C$7
But I would like it to look like this
=PHQChartQuery!$A$2:$C$500
But when I do there there alot of extra points on the graph. I would like
it to only show on the graph only the rows that have data in them and then if
I add data later on it will update the graph. So I don't have to keep
redoing the range everytime data is entered.
Is this possible?