how to remove "0" when pulling from a blank cell

[mufan]

Hi,
I have a worksheet that pulls data from another worksheet. However, when there is nothing in a cell it will add a zero to the worksheet that I am pulling it into. Then, when I try to graph the data it sees it as a zero. Can I make it so that if there is nothing in the cell of the sheet I'm pulling data from then it will just leave the cell blank that I am adding it to? Thanks!

[Whizbang]

Try this.
=If(Sheet1!A1="","",Sheet1!A1)