topic Re: Quality of MS Excel Charts in Exported Map Products in ArcGIS Mapping and Charting Questions

Quality of MS Excel Charts in Exported Map Products

JustinOdell — Sat, 10 Mar 2018 03:51:54 GMT

I have an ArcMap layout containing some MS Excel charts. I am familiar with the ability to dynamically link the charts via Insert > Object, however I don't believe this to be fit for my purpose because I wish to create a raster catalog containing images of the charts so that I can cycle them through products in a data driven fashion.

So I have experimented with converting my Excel charts to a number of different image formats including PNG, JPG, BMP, TIF. Regardless of which format I am using, every time I export the product to PDF the quality of the Excel charts degrades to a point where I don't feel they are useable.

I can achieve the desired level of quality when I copy and paste the chart directly from Excel to ArcMap, but this method means I am unable to utilise data driven pages.

Does anybody have a suggestion about how to best tackle this issue?

Re: Quality of MS Excel Charts in Exported Map Products

JosephCarter — Mon, 12 Mar 2018 13:48:04 GMT

Hi, Justin. Try this. . . .Copy and insert your Excel Chart as a "Picture" in ArcMap using Paste Special/Picture. When exporting to PDF, use: General Tab, Export Map/dpi 400/. . .Image Quality "Best",/ Format Options, RGB, Compress Vector Graphics (Off), Adaptive, JPEG Quality "Max", Vectorize Layers . . , Convert Marker Symbols . . (Off), Embed All. . Fonts (Checked). You should get a clean chart image in your new PDF.

Good luck!,

Joe

Re: Quality of MS Excel Charts in Exported Map Products

JosephCarter — Mon, 12 Mar 2018 14:08:11 GMT

It should be noted to the previous that PDF is not a supported file type in a raster catalog. That is why I added the above workflow. . .