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