software

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: www.excelforum.com/member.php...oamp;userid=31409
View this thread: www.excelforum.com/showthread...hreadid=511107Hi,

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.

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
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
PeltierTech.com/
_______

quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; I don't think you can do exactly what you want but have a look at these
gt; articles on charting from named ranges. Perhaps you can build a named from
gt; from you information. Have not had a chance to tested this but maybe use
gt; INDIRECT() in the named range.
gt;
gt; peltiertech.com/Excel/Charts/Dynamics.html
gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt; www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
gt;
gt; Cheers
gt; Andy
gt;
gt; jeaton wrote:
gt;gt; Hello,
gt;gt; When building a line chart, and defining series values, is there a way
gt;gt; to point to a cell that contains the cell address of the beginning
gt;gt; point of the series and another cell that contains the cell address of
gt;gt; the ending point in the series? The same with the x-axis too. Thanks
gt;gt; Jeff
gt;gt;
gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info