Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Handle missing values
Hi! I have a data set that sometimes contains missing values (#MISSING!). I
want to make graphs of the data and I want the graph to just skip the missing values. How can I do that? Most thankful for any help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Handle missing values
The cells say "#MISSING!"?? How unfortunate.
Either delete all the #MISSING! entries in the table (to leave blank cells), replace them with #N/A! (works best for line and XY charts), or build a table linked to the first with formulas like =IF(ISNUMBER(A1),A1,NA()) where NA() produces #N/A in the cells. Use this second table as the chart source data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Arne Hegefors" wrote in message ... Hi! I have a data set that sometimes contains missing values (#MISSING!). I want to make graphs of the data and I want the graph to just skip the missing values. How can I do that? Most thankful for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Second x-axis values missing | Charts and Charting in Excel | |||
missing values | Excel Discussion (Misc queries) | |||
Missing values from SAS | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |