LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"If" statement returning blank gives downstream formula errors. Johnboy Excel Discussion (Misc queries) 2 February 26th 07 05:26 PM
Returning a string of values in an IF statement Dave F Excel Discussion (Misc queries) 1 January 11th 07 01:33 AM
How, on a line chart, to skip blank entry rather than plot as 0? JohnTerp Charts and Charting in Excel 1 July 12th 06 11:11 PM
Returning Specific Cell Content using IF Statement weeclaire Excel Discussion (Misc queries) 0 February 17th 06 09:25 AM
Stopping chart line where 1 of 2 columns of data in calculation is blank Roger B. Charts and Charting in Excel 2 July 17th 05 07:32 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"