| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you very much
"Jon Peltier" wrote: In that case, you need to remove the point from the data being plotted. The best thing to do is make a copy of the data, construct the chart with the copied data, and delete from the copy any outliers. The chart calculates a trendline using every plotted point, whether you hide it or not. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Vicky wrote: Jon, I would like to remove it from the calculation of the trendline. Thank you. How do I do that? Vicky "Jon Peltier" wrote: Do you want to hide the point, or remove it from the calculation of the trendline? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Vicky wrote: Is there a way to remove the value of a data point so that it doesnt skew the data in a scatter or line chart. In other words, I would like to be able to conceal the data point(s) which are not within the trendline. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Hybrid Mode
