07-04-2009, 01:33 PM
|
|
Registered User
|
|
Join Date: 04 Jul 2009
Location: Milan, Italy
MS Office Version:Excel 2004
Posts: 2
|
|
|
How to get empty cells not to show up on graph (not even as 0 )
HI everyone! I am a newbie Excel user, but I have a Q on behalf of my brother, who usually uses excel for finance charts and such...
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... so far if he has the cell return nothing, then the graph shows a zero, but he would like it to just be blank. Also, he said he could get the formula in the cell to return a letter to be then recognized as nothing, thus not showing up on the graph... does this make sense?
Also, he is wondering if it is possible to set up a cell so that its formula displays a result in a different cell... 
Thanks y'all! Sorry about my ignorance in this matter, but medicine is more my thing than excel :D
|