How to eliminate outliers in graph

[plumberef]

When viewing some graphs, sometimes I need to ignore some outliers. See attachment.

Like to know whether it is possible to click on the outlier data or the corresponding x on the x axis and the graph will be updated without this outlier data.

I know I can go to the data set and remove the outliers but want to simplify by doing it on the graph.

Many thanks.

[Andy Pope]

You would need to use chart events. If you select a specific data point you can then decode the series formula to the the range and clear the contents.

Probably much easier to simply clear the cells manually.

[plumberef]

You would need to use chart events. If you select a specific data point you can then decode the series formula to the the range and clear the contents.

Probably much easier to simply clear the cells manually.

OK, manual way then.

Thanks.

[Steve=True]

Hi Plumberef,

There may be a formulaic way to do this if you have a value on what constitutes an outlier.

Although you are not choosing the points to remove from the graph, I set it up so that you can do it with an outlier number that eliminates the data points that are outside this amount from point to point.

How-to Eliminate Statistical Outliers in an Excel Line Chart

Let me know what you think. Hope this helps.

Steve=True

[plumberef]

Hi Plumberef,

There may be a formulaic way to do this if you have a value on what constitutes an outlier.

Although you are not choosing the points to remove from the graph, I set it up so that you can do it with an outlier number that eliminates the data points that are outside this amount from point to point.

How-to Eliminate Statistical Outliers in an Excel Line Chart

Let me know what you think. Hope this helps.

Steve=True

Many thanks Steve!

Will digest it. Bookmarked your link for future use.

Cheerio.

[Steve=True]

Hi Plumberef, you are welcome.

I decided to take it a step further and considered how we can get the gaps in the outlier line chart.

I started with a post that Andy Pope ("The Master Chart Maker") did years ago that used a masking technique to cover over the visible lines with a white line. There can be a few problems using that technique. So I tried to come up with a different solution.

Andy, thanks for making me think that something like this is even possible You are awesome!

Here is my step-by-step tutorial and video demonstration on this technique:
How-to Show Gaps in a Line Chart When Using the Excel NA Function

Thanks and let me know what you think.

Thanks

Steve=True

[Andy Pope]

Good job Steve.

[plumberef]

Hi Plumberef, you are welcome.

I decided to take it a step further and considered how we can get the gaps in the outlier line chart.

I started with a post that Andy Pope ("The Master Chart Maker") did years ago that used a masking technique to cover over the visible lines with a white line. There can be a few problems using that technique. So I tried to come up with a different solution.

Andy, thanks for making me think that something like this is even possible You are awesome!

Here is my step-by-step tutorial and video demonstration on this technique:
How-to Show Gaps in a Line Chart When Using the Excel NA Function

Thanks and let me know what you think.

Thanks

Steve=True

Excellent! Many thanks & much appreciated!