Plotting a trapezoid on a chart and calculating its area

[keerthana_k]

Hi All,

I am trying to plot a trapezoid over a chart and calculate it’s area to find a value that I am interested in. Please refer image.
If I can get the length of the two sides and the height from base, then I can calculate the area of the trapezoid. Is there any in-built function to do this? Or else is there a way I can plot the trapezoid over a chart and find the necessary values?

[keerthana_k]

The reason I need to approximate is I need to intrapolate the values using percentile.

[lukejadamec]

I don't understand why you want to approximate that which can be determined exactly with less work.

[jtrucks · Accepted solution]

You might be able to do this using some of the external visualization libraries via the API, but there is no built-in function that would calculate that information for you unless you have the datapoints and could perform all the math using eval yourself.

[keerthana_k]

I used custom python script to achieve this.