| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Not plotting null or text data
I am trying to plot data from cells that have a conditional that returns
either a null "" (I could also make it text) or numerical data. I wish only to plot the numerical data, but the null (or text) data plots as zero no matter what I do. Since the states of various cells may change, I don't wish to exclude those cells permanently. Any thoughts would be greatly appreciated. Thanks in advance. -- Vince F |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Not plotting null or text data
Hi,
As far as charts are concerned "" is text and as such is plotted as zero. Use NA() instead, charts will interpolate the points. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Vince F" wrote in message ... I am trying to plot data from cells that have a conditional that returns either a null "" (I could also make it text) or numerical data. I wish only to plot the numerical data, but the null (or text) data plots as zero no matter what I do. Since the states of various cells may change, I don't wish to exclude those cells permanently. Any thoughts would be greatly appreciated. Thanks in advance. -- Vince F |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Not plotting null or text data
Andy
That works, thanks! -- Vince F "Andy Pope" wrote: Hi, As far as charts are concerned "" is text and as such is plotted as zero. Use NA() instead, charts will interpolate the points. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Vince F" wrote in message ... I am trying to plot data from cells that have a conditional that returns either a null "" (I could also make it text) or numerical data. I wish only to plot the numerical data, but the null (or text) data plots as zero no matter what I do. Since the states of various cells may change, I don't wish to exclude those cells permanently. Any thoughts would be greatly appreciated. Thanks in advance. -- Vince F |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop chart from plotting null values as zeros in excel 20 | Charts and Charting in Excel | |||
| If statement that outputs specific text if cell is not null | Excel Discussion (Misc queries) | |||
| Plotting data from 2 tabs | Charts and Charting in Excel | |||
| Data Validation for Null | Excel Worksheet Functions | |||
| Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
Hybrid Mode
