Hi – I have a Spline Chart something like your example (http://www.jqwidgets.com/wp-content/uploads/2012/02/jquery-chart-spline.png) where lets say one of the lines is dependent on data sample of another one. e.g. in this example, lets say, Building Cost should automatically grow when Interest Rate would increase.
What I want is –
1. To drag Interest Rate to a higher/lower position in the chart and find out how much increment (+ or -) is happening to Building Cost. The Rate of Increment (+ or -) should be calculated from historical data based on which the chart has been rendered.
2. I should be able to save the new data points in an excel.
Can anyone please help me with inputs on this? Is this possible with out of the box features, otherwise how can this be achieved? An example would greatly help.
Thanks in advance.