Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
fit a trend line w/o outliers
Hello,
I made a simple scatter plot in Excel and found an outlier. I want to keep the outlier anyway in the chart while fitting a trend line with all the data points but the outlier. How should I do? Thanks, David |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
fit a trend line w/o outliers
Hi David,
Add a helper column which returns either the value or #N/A depending on whether the value is within or outside of your limits. Add this series to the chart as well, and add the trendline. Dave url:http://www.ureader.com/msg/10295852.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart trend-line | Excel Discussion (Misc queries) | |||
Which trend line? | New Users to Excel | |||
Trend line | Charts and Charting in Excel | |||
trend line does not appear | Charts and Charting in Excel | |||
trend line | Charts and Charting in Excel |