- is it possible to have cells in a spreadsheet that delivers input to a graph?
Lets assume that you have graph that holds the following:
And part of this 'series' is to take input from a cell in the spreadsheet (in which the graph recides); assume further that a cell gives the following 'contribution' to the graph: $UK$ - and it is derived from a formula.
The formula which the cell that gives the input to the graph is the following;
In this instance it returns: $UK$
How do I incorporate the formula into the graph-series? Is it doable?