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?