Visual using trigonometric functions: curve and dots

[drakko]

Hi all,

I'm looking for a way to build a visual where that kind of a red line would become present.

I've seen an intelligent solution with trig functions but cannot implement the PQ code properly (https://querypower.com/2017/06/09/drawing-homer-simpson/).

The task I have is solving the problem described below in quotes "".

Any help much appriciated.

"The active sum (AS) and the reactive sum (RS) are calculated individually for each stakeholder. These two parameters become the stakeholder’s coordinates on the Balance of Power Map. AS is a measure of the total impact of a given stakeholder on the environment, i.e., the other stakeholders. RS is a measure of the total impact of the environment on a given stakeholder, indicating their susceptibility to the influence of other stakeholders.

AS and RS are then multiplied and divided in order to obtain a product (P value), and a quotient (Q value) respectively, for each stakeholder. The Q value indicates whether a given stakeholder is, in general, active (Q > 1) or reactive (Q < 1). The linear function y = x (Q = 1) plots a straight line that divides the coordinate system into the active and reactive sections. It is assumed that if a variable is relatively close (+/-20%) to the straight line y = x, its role is neutral (neither particularly active nor reactive). The ‘neutral area’ on the Balance of Power Map is marked out by the straight lines with the following equations y = tg36*x and y = tg54*x.

The P value indicates the level of significance of a stakeholder’s role in the environment, defined as the ability to affect the way the environment behaves. The higher the relative P value, the more critical the role of a stakeholder for the environment, meaning that it is strongly involved in interactions with other variables (it is highly participative). It is assumed that critical variables are located above a hyperbole with the equation y = a / x, where a is the product of coordinates of the intersection point of the straight line y = x and the straight line plotted through the points (x; ASmax) and (RSmax; y). In turn, the further below the hyperbole towards the bottom left corner of the map a variable is located, the more buffering its role is. Figure 8 explains the general interpretation of a stakeholder map."

So the dummy data attached is AS, RS, and Q and P calculated. The column Category will then serve to show the dots on the grpah (dots will become devided by the curve for easier interpretation). Is this even possible? - after righting the message I see I cannot attach the sample data file (screen instead).