52
1
CONVERTING WORD TO PDF FOR POD (WITHOUT TEARS)
This is a guide (for PC) for authors who intend to self-publish through print on
demand (POD) printers
—
Createspace (CS) or Lightning Source (LSI) Inc. You
may download this free resource from: www.bubble-value-at-risk.com
, which
also contains the disclaimer and terms of use for this document.
Inserting Excel Charts into Word
For most technical books, Excel provides the most convenient tool to create
charts. Unfortunately there are a few compatibility issues to avoid
—it’s a min
e-
field for the unaware.
First, the chart you see on the Excel screen is not the same size as what goes
into your book. What looks like a reasonable size to the human eye on Excel is
probably about 14cm on a book (too big!). To see the size, highlight the chart, go
to: Format
Size.
Don’t bother resizing it in Excel, because zoo
ming/un-
zooming the Excel screen will mess up the width & length in an unpredictable
way (it’s a bug
in version 2007!).
If you have many charts for your book (suppose it’s a text book),
you may use
the VB codes in the Appendix to standardize the size of each charts. (Cut/paste
the codes into the Visual Basic editor in Excel). To use it, highlight the chart, and
run the macro Resizechart(). Charts are best in pure black, with a minimum line
thickness of 1.0, otherwise it may not come out well in print. I have included an
outer black border, which I don’t really
want (it will be used for trimming in Pho-
toshop later).
Second, you cannot cut/paste the chart to any other application via the clip-
board
—
it will automatically reduce the picture resolution to 72 dpi (dots-per-
inch). POD printing requires 300 dpi or higher. You can still cut/paste into Pho-
toshop at 72 dpi and convert it later to 300 dpi (which the POD-printer will ac-
cept) but the image quality would have deteriorated. There is a way to export the
file using a VB code but this works only for GIF, PNG formats
—
POD printing
requires a loss-less file format called TIFF.
One solution is to save the chart into PDF format first! Highlight the chart,
and save as PDF using the settings as per Figure 1. This will then be at 300 dpi.
Next you need a copy of Photoshop. Download a trial version from:
www.adobe.com
. This will give you 30 days usage, so I suggest you do your
charts last in your book project. Open the Pdf file from Photoshop as in