Elizabeth Posted September 19, 2019 Report Share Posted September 19, 2019 For an Excel chart with many data points I need to know the best way to achieve a quality image with smallest file size I can achieve in PDF. Converting from Excel using the Nitro add-in or Microsoft print to PDF results in large size, even when selecting WebSize in settings. Specifically one detail I want to know about is the detailed rendering of these charts' data points. After using this method, I can see individual dots in the scatter chart rendering on the page on the PDF, as if it is keeping all the original data and not using a flat image of the chart. Can this be avoided when converting from Excel directly? Note, in the PDF after conversion the charts aren't recognized as images, rather all parts of the chart are recognized as individual objects. Copying the chart into Word first (before converting to PDF), I can get a smaller file size in the resulting PDF, though you can definitely see image quality is lost. The best way I can achieve high quality and small file size at the moment is either of these two methods: Excel > print/convert to PDF > take a screenshot of the PDF > copy and paste image into PDF Excel > print/convert to PDF > export as image (configure desired DPI settings when doing so) > copy and paste image into the PDF I'm jumping through a lot of hoops to get the quality and file size optimized. It would be really helpful/useful if there was a feature to select a section of the PDF and somehow convert that portion to a high-quality image, instead of each little point/dot rendering as an individual object in the PDF. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now