| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
IF statement not returning a blank so a chart line won't gap
I have an IF formula that should return a blank to a cell using the "". but
the chart does not recognize it as a blank and drops the shart line to zero instead of showing a gap |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
IF statement not returning a blank so a chart line won't gap
Replace the "" in your formula by NA()
-- David Biddulph "mikekaf" wrote in message ... I have an IF formula that should return a blank to a cell using the "". but the chart does not recognize it as a blank and drops the shart line to zero instead of showing a gap |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
IF statement not returning a blank so a chart line won't gap
On Wed, 2 Jan 2008 12:19:01 -0800, mikekaf
wrote: I have an IF formula that should return a blank to a cell using the "". but the chart does not recognize it as a blank and drops the shart line to zero instead of showing a gap The chart interprets "" as 0 so if you replace the "" with NA() in your IF formula your chart will show the gap correctly. -- Cheers . . . JC |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
IF statement not returning a blank so a chart line won't gap
The chart will not show a gap. It will omit a marker at this X value, but if
the markers are connected with lines, the line will connect the points on either side of the missing marker. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JC" wrote in message ... On Wed, 2 Jan 2008 12:19:01 -0800, mikekaf wrote: I have an IF formula that should return a blank to a cell using the "". but the chart does not recognize it as a blank and drops the shart line to zero instead of showing a gap The chart interprets "" as 0 so if you replace the "" with NA() in your IF formula your chart will show the gap correctly. -- Cheers . . . JC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
| Returning a string of values in an IF statement | Excel Discussion (Misc queries) | |||
| How, on a line chart, to skip blank entry rather than plot as 0? | Charts and Charting in Excel | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| Stopping chart line where 1 of 2 columns of data in calculation is blank | Charts and Charting in Excel | |||
Linear Mode
