Passing a cell value into a text box on a graph

[John Clarke]

Please help.

I am trying to pass a value from a cell onto a graph. The graph is
plotting culumative variance against a plan but the gap in the early
days is very small. So I need to publish the gap between plan and
actual on the graph.
I want to automate the update of the gap on opening the spreadsheet or
pressing a button.

The calculation of the gap is no problem for me, its the putting the
answer onto the graph is the issue.

I thought I could do it via a text box on the graph.

Thanks in advance

John

 

[John Clarke]

Please help.

I am trying to pass a value from a cell onto a graph. The graph is
plotting culumative variance against a plan but the gap in the early
days is very small. So I need to publish the gap between plan and
actual on the graph.
I want to automate the update of the gap on opening the spreadsheet or
pressing a button.

The calculation of the gap is no problem for me, its the putting the
answer onto the graph is the issue.

I thought I could do it via a text box on the graph.

Thanks in advance

John