Transparency of missing values is currently only supported in image plots, which was introduced in version 7. In that plot type, you can bring up Plot Details dialog, and there is a "Missing values as transparent" checkbox that you can check to make missing values transparent.