Indirect chart source data

[jeaton]

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]

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/newsgroups/dynamic_charts/index.html
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm

Cheers
Andy

 

[Jon Peltier]

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/
_______