How can I export chart from excel into Latex with high quality(Overleaf)?

Title says it all, we have data in Excel and we have found Kutools to create pdf files from tables , but it is not working for charts. We have tried export graphs into png, pdf and it has low quality after uploading into overleaf. Do you have any tool or tip which can help me ?

Thanks

1 Answer

Click File > Save As (> Browse on Office 2016 and newer).

Now select PDF under "Save as type".

Make sure "Optimise for standard" publishing is selected. Set options as required under "Options". Now click "Tools" next to save, and change "Compress pictures" to 300 DPI. Perhaps also change the DPI setting under Tools > Web options"

BTW, If you have multiple graphs each in their own sheet, hold shift and select all the sheets before doing the above.