Hi,
This may be beyond excel but I thought I'd ask anyway.
There are 3 parts to my sheet.
1) A graph, a yield curve.
2) Some data entry separate to the graph..
3) Some KPI's which are formulas based on the graph data and the data entry.
What I want to do is use the mouse to change the shape of the graph and have that change flow through to the graph data and therefore change the KPI's automatically.
Is this possible?
Thanks in advance....
This may be beyond excel but I thought I'd ask anyway.
There are 3 parts to my sheet.
1) A graph, a yield curve.
2) Some data entry separate to the graph..
3) Some KPI's which are formulas based on the graph data and the data entry.
What I want to do is use the mouse to change the shape of the graph and have that change flow through to the graph data and therefore change the KPI's automatically.
Is this possible?
Thanks in advance....