Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot "" as empty rather than zero in a chart
I have an if statement that either populates cells with a numeric value or
blank, i.e. "". I then want to chart the result. For example, I might have the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values "" are interpreted as zero. If I truly have empty cells my plot is fine, only plotting the 56,,85,75, . But since there is 'something' in the cell, i.e. "", it wants to plot something. Is there a way to either populate the empty cells with a code of some kind that would not plot, or somehow tell the chart wizard to not to plot "" ? I'm using Office 03 at work and 07 at home. I have the same problem with both. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot "" as empty rather than zero in a chart
Use NA() instead of ""
-- David Biddulph "Russell.Ivory" wrote in message ... I have an if statement that either populates cells with a numeric value or blank, i.e. "". I then want to chart the result. For example, I might have the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values "" are interpreted as zero. If I truly have empty cells my plot is fine, only plotting the 56,,85,75, . But since there is 'something' in the cell, i.e. "", it wants to plot something. Is there a way to either populate the empty cells with a code of some kind that would not plot, or somehow tell the chart wizard to not to plot "" ? I'm using Office 03 at work and 07 at home. I have the same problem with both. Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot "" as empty rather than zero in a chart
"David Biddulph" wrote: Use NA() instead of "" -- David Biddulph "Russell.Ivory" wrote in message ... I have an if statement that either populates cells with a numeric value or blank, i.e. "". I then want to chart the result. For example, I might have the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values "" are interpreted as zero. If I truly have empty cells my plot is fine, only plotting the 56,,85,75, . But since there is 'something' in the cell, i.e. "", it wants to plot something. Is there a way to either populate the empty cells with a code of some kind that would not plot, or somehow tell the chart wizard to not to plot "" ? I'm using Office 03 at work and 07 at home. I have the same problem with both. Thanks That works perfectly, thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot find "Plot empty cells as" option in 2007 | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
Can "y" be determined for a given "x" on a smoothed x-y plot | Charts and Charting in Excel | |||
modifying the area plot to a "top-hat" instead of a "saw-tooth" | Charts and Charting in Excel |