| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you ignore a data point?
Say my data set is
10, 15, 90, 12 I want to plot all the values but not connect/interpolate 90 as it is an outlier. How do I do this, I'm sure it's easy. Many Thanks Julie |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do you ignore a data point?
Make two series, one with the three good points, one with the outlier.
Connect the points in the first series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ju1eshart" wrote in message ... Say my data set is 10, 15, 90, 12 I want to plot all the values but not connect/interpolate 90 as it is an outlier. How do I do this, I'm sure it's easy. Many Thanks Julie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| Charts that ignore certain data | Charts and Charting in Excel | |||
| What is the point of Data-Validation-Ignore Blank? | Excel Discussion (Misc queries) | |||
Linear Mode
