| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph ignoring anomalies
Could anyone tell me how I can plot a line graph, but ignore points that are
anomalies (eg points that are 0)? Thank! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
graph ignoring anomalies
You could delete the anomalous values. Or if the values are returned by a
formula, change the formula to return NA() instead. =IF(A10,A1,NA()) This leaves #N/A in the cell, but you can hide this with conditional formatting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rjkmidget" wrote in message ... Could anyone tell me how I can plot a line graph, but ignore points that are anomalies (eg points that are 0)? Thank! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Out of range line disappears in print as it re-enters graph | Charts and Charting in Excel | |||
| Combination Line and Bar Graph | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| ignoring null values in graph | Charts and Charting in Excel | |||
Hybrid Mode
