Is there a way to calculate the value of Y for the given value of X for Scatter Chart

[Zhenyu Hu]

Dear All,

I am using google chart api to draw a scattered polynomial trend line.

Is there a way to calculate the value of Y for the given value of X for Scatter Chart? 

I didn't find existing method to do that, however I can get the equation text, I think I can parse the text equation and do the calculation using JS, but I don't know whether it is a good solution, it should be a easier way to do that.

Does anybody know how to do that?

Thanks a lot,

Kevin

[Andrew Gallant]

To the best of my knowledge, you cannot get the calculated value of a trendline point for a given x-value from the chart.  You can make a feature request to add support for getting the calculated value of a trendline point, if you like.

[Stas S]

Can you please show how to get the equation text?

On Wednesday, October 15, 2014 at 2:13:50 AM UTC+3, Zhenyu Hu wrote:

... however I can get the equation text ...