Another 2 ways in the attached:
On Sheet1, an Autofilter has been applied to column J to keep only rows where the value is greater than 14
On Sheet2, the number 14 has been entered in cell L1. This number is used in the formulae in the cells in column K, to show the number in column J if it's greater than the value in cell L1 or #N/A if it's not. It's this column K which is plotted.

Attached Files

msofficeforums52909.xlsx (21.4 KB, 4 views)

Thanks to all, I appreciate so much!
solution on sheet2 seems to be more easy for me to work with.
Attached the table with some more data, could you pls check it ?

Thanks!

Attached Files

msofficeforums52909 01.xlsx (23.0 KB, 6 views)

See attached Sheet2. Also Sheet1 tweaked using the other method.

Attached Files

msofficeforums52909 01a.xlsx (23.5 KB, 5 views)

Thank you Logit, but for my purposes it is easier the solution Sheet 2 from p45cal.
Could the graph in sheet 2 be done with a line instaed of ponts?

Thank you !

As follows:2024-10-14_210858.jpg


or:


2024-10-14_211223.jpg

Good! Thanks a lot!

.... can we make appear on X-axis only the values in the column, 15,4 - 17,8 - 19 - 21,5 - 22,1 - 33,4 instead of 5-10-15-20....
Thanks!

With difficulty (if at all).
Does the chart at cell M25 of Sheet2 do anything for you?

Attached Files

msofficeforums52909 01b.xlsx (32.1 KB, 4 views)