Plot graph for dynamically changing values in a single cell

[yorkuvir]

Hello guys,

I have data from A2 to A14 in an Excel sheet, for which a linear graph can be displayed next to the data.

I wish to plot the same graph but while I have the data ONLY in A2, which changes subsequently (and there is no data anywhere else in the worksheet).

That is, as soon as the A2 cell's data changes dynamically, I wish the graph to update linearly automatically.

How do I do that?

Thanks in advance.

Cross-posted here: https://www.excelforum.com/excel-general/1195101-plot-graph-for-dynamically-changing-values-in-a-single-cell.html

 

[yorkuvir]

OK; since nobody has responded, I will assume it is not possible, and look for other options. Thanks.