Chart changing data from one cell?

To answer directly your question: No, unless you mean a chart with one datapoint only.

But what if we really want/need it?

The event of changing cell shall copy this value to first empty cell in some kind of "archive" sheet / range. And the (probably dynamic part of this range (or may be whole range) shall be used as a datasource for the graph.

How to do it in your particular case - depends heavily on mechanism by which this changing cell is populated and not so heavily on type of graph and probably also on some characeristics of the particular workbook - sharing? already built in event handlers etc.

Have you went through http://www.excelforum.com/forum-rule...rum-rules.html ? Especially section
Want to get your question answered quickly?