Excel -> PDF conversion issues

[QuantBurner]

Can anyone give some tips on best practices for setting up graphics (text boxes, lines, and other shapes) on a sheet so that when the worksheet is converted to a PDF the objects are where they should be? For example, it seems that zoom level affects the placement of objects in the PDF. For instance at ActiveWindow.Zoom = 85 all my shapes are shown EXACTLY where I want them and then in the resulting PDF, text boxes, rectangles, etc overlap chart objects (like the legend and axis). Very annoying!
Thanks in advance for any help!

 

[anandvarma]

if you are using the Excel 2007 or later then it available in excel itself to convert file to PDF

if you are using the Excel 2003 then best option is free PDFcreater at www.sourceforge.org
it is free