Indirect chart source data

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


--
jeaton
------------------------------------------------------------------------
jeaton's Profile: http://www.excelforum.com/member.php...o&userid=31409
View this thread: http://www.excelforum.com/showthread...hreadid=511107

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

When I saw this post, I said, oh sure, it's easy. I set up the names range
using INDIRECT, and all of Excel recognized the name, except of course, for
the chart. I tried a number of ways, and finally put it off, because I had
work to do. (I think I knew that charts don't recognize names constructed
with INDIRECT, because I don't use INDIRECT in any of my defined names.)

Thanks Andy for bailing us out.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Andy Pope" wrote in message
...
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