Imported Excel spreadsheet displayed in PDF map with graphic issues

4273
6
Jump to solution
08-20-2014 07:49 AM
MariaJosefson
New Contributor II

I am inserting excel spreadsheets into my large-format map using Insert -> Object -> Microsoft Excel Worksheet option, then cut-pasting the data and formatting it inside Excel. When I export the finished map, the font and lines of the uniformly-formatted spreadsheets vary in boldness (see example below). I am exporting into PDF at 400dpi (any more, and I am afraid the file size will become too massive). The map is intended for printing and sending to other parties. Any advice on how to rectify this situation?why.JPG

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
SimonShin
New Contributor II

Dan is right, my guess is that what you are seeing is a DPI issue on display only. Once LCD monitors start implementing "retina" like resolution (we can thank Apple for leading the way on upping higher resolutions on mobile devices), we'll see that the varying thickness/lineweights on screen is just an issue of a lines deciding which pixels to display and the resolution is the concern on the monitor. Even at 1080 vertical pixels on your screen (if it is even that high), it is not nearly enough to see at "print quality".

View solution in original post

0 Kudos
6 Replies
DanPatterson_Retired
MVP Emeritus

To my eye, it appears that the background color is making the font appear more bold than it actually is and I doubt that it can be rectified unless you wanted to have a uniform background color which would obliterate what lies underneath

0 Kudos
MariaJosefson
New Contributor II

Here's some more text that is over a fairly uniform background (the background is set to fade out towards the edges, but it's clear that the first column has a different pattern of text "boldening" and fading than the next two, as they come from two different spreadsheets). example2.JPG

0 Kudos
DanPatterson_Retired
MVP Emeritus

Print it...what does it look like...my eyes are still seeing background associated with certain letters...

JenniferMinnick
Occasional Contributor

I see the variations but I second the "print it" suggestion.

There often seems to be a lack of "clearness" when viewing graphics items or even vector items in the layout view in ESRI and in the pdfs.

SimonShin
New Contributor II

Dan is right, my guess is that what you are seeing is a DPI issue on display only. Once LCD monitors start implementing "retina" like resolution (we can thank Apple for leading the way on upping higher resolutions on mobile devices), we'll see that the varying thickness/lineweights on screen is just an issue of a lines deciding which pixels to display and the resolution is the concern on the monitor. Even at 1080 vertical pixels on your screen (if it is even that high), it is not nearly enough to see at "print quality".

0 Kudos
MariaJosefson
New Contributor II

It turned out to indeed be an issue of my LCD screen! When I printed the pdf in all its 36x48" glory, the lines looked identical to each other. The background, on the other hand, was doing weird in-bands stuff, so I will be switching it to a uniform background after all. It looked so nice on my screen! Thanks everyone for your feedback.

0 Kudos