| T O P I C R E V I E W |
| skgdt330 |
Posted - 12/04/2024 : 1:49:13 PM
This is a graph obtained by integrating a curve starting from its maximum value.
I want to find the points corresponding to 10% and 20%, draw lines at those points, and calculate the x-intercepts. How can I do this? |
| 2 L A T E S T R E P L I E S (Newest First) |
| NicholasSupport |
Posted - 12/04/2024 : 3:18:41 PM
Subscribing to this topic. |
| snowli |
Posted - 12/04/2024 : 3:16:36 PM
Hello,
I suppose you want to draw vertical lines at where 10 and 20 percentile is in graph.
Go to the worksheet where the integration result is (usually it's in same sheet as original data)
You can add F(x) formula e.g. to calculate percentile values (column D) and where corresponding X is (column E).
Then in graph, double click X axis to add reference line at col(E)'s location. See the "Reference Lines at Value" setting on top of the dialog.
Thanks, Snow |
|
|
