Thread: How to get empty cells not to show up on graph (not even as 0 )
View Single Post
  #3  
Old 07-04-2009, 03:03 PM
shg's Avatar
shg shg is online now
Forum Guru
  
Join Date: 21 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,333
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: How to get empty cells not to show up on graph (not even as 0 )
Quote:
He is wondering if it is possible to excel to see a cell and if it is blank not to display it in a graph.
Cells that are #N/A are ignored in charts. So if there is a formula like this,

=IF(someCondition, someExpression, "")

... it can be changed to

=IF(someCondition, someExpression, NA())
Quote:
... he is wondering if it is possible to set up a cell so that its formula displays a result in a different cell...
No; a formula returns a result to the cell in which it appears. There are probably other ways to achieve what he wants, though.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote