Making an upper and lower line on a dotchart that removes all the dots over the upper line and under the lower linne.

[erlend.wahl]

I need this at work to make things go a lot faster, are there anyone that can help me with this?

I have a lot of dots from a test plotted into a chart, and I want to remove the odd dots, that do not follow the pattern the rest of the dots. Therefore I need a way to remove these without having to do it mannualy.

 

[Steve=True]

Hello erland,

Welcome to the FORUM!

I would recommend using the NA() function.

You can see a sample of a similar chart you describe here.

How-to Plot Building Wall UR Value in an Excel XY Scatter Chart

Please let me know if this helps.

Steve=True