Hi,

I don't think you can do exactly what you want but have a look at these
articles on charting from named ranges. Perhaps you can build a named
from from you information. Have not had a chance to tested this but
maybe use INDIRECT() in the named range.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

jeaton wrote:
Hello,
When building a line chart, and defining series values, is there a way
to point to a cell that contains the cell address of the beginning
point of the series and another cell that contains the cell address of
the ending point in the series? The same with the x-axis too.
Thanks
Jeff



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info