I tried both MS paint and MS word, then saved as image but DPI is 96, conversion from 96 to 300 DPI through software dose not improve image quality, I am looking for direct method to save Excel graphs to 300 DPI
I'm sorry. The last message went out incomplete. I use this tool: https://www.xltoolbox.net/ With only one click (well... maybe two), you can generate high-resolution images especially for academic publication. Actually, the author is an academic that was tired of copying his Excel graphs to edit them in Paint. It's an add-in for MS Excel, and generates images in PNG and JPG format. It's free, it's reliable, it's light, it's easy to use. I'm absolutely not related to the producers of that tool. I'm just a simple user that finds it great and wants to share it. The bad news? It can't be used in Mac.
I use the following method. Copy the excel graph and paste it in Microsoft image digital editor. By clicking on the section resize image, you can manipulate the resolution as well as size of the image. The same can be done in Photoshop also. It is not possible in MS paint.
my suggestion is to convert it into a vector format:
For this make sure you have a pdf printer installed. Mine came with the windows office package that I am using, but you can also download various versions for free from other sites. Rather then printing out on paper they will create a pdf (which is a scalable file) and save it. Select the graph you want to make into a pdf, select print and choose the pdf printer as the output device. You can then open the newly created pdf file and manipulate it for example in inkscape or GIMP (free software) or adobe illustrator (costs) and save it as an SVG (scalable vector graphic). Inkscape for example will also allow you to export back into another format when you have manipulated or scaled up the graph or you can import SVG files into many other applications.
Hi, I have tried a couple of ways (as publication materials always require minimum of 300dpi for figures), and found that this way by University of Kent is the best. It works for me, and hope it will be helpful for you too.
You may use graphpad prism program (free for one month) or licensed version it do it easily by copying the graph and pasting it in the program and export it with the desired resolution 300, 600, or 900 DPI.
As an alternative method, if you install the Dplot you can easily plot any graph with different formats and resolutions. Once you install Dplot you would have an extension on the excel sheet, in add-ins tab.
I'm sorry. The last message went out incomplete. I use this tool: https://www.xltoolbox.net/ With only one click (well... maybe two), you can generate high-resolution images especially for academic publication. Actually, the author is an academic that was tired of copying his Excel graphs to edit them in Paint. It's an add-in for MS Excel, and generates images in PNG and JPG format. It's free, it's reliable, it's light, it's easy to use. I'm absolutely not related to the producers of that tool. I'm just a simple user that finds it great and wants to share it. The bad news? It can't be used in Mac.
In Excel, right click on the graph and choose "Save as picture," and save it as a PDF file. Then open the PDF file and go to File>Export, and under Format choose JPG, then set the resolution to 300 pixels per inch and save. (I am using a MacBook so I'm not sure if this works on other computers)
We faced with the same problem and solved it using IsfanView that can be downloaded for free from the official website: https://www.irfanview.com/
It tooks several minutes to solve the image resolution. We used "Image" and after "Resize/Resampling" and on the tool box you can install the needed DPI. After you save the picture in necessary format.
I solved this issue simply copying and pasting the graph from Excel to MS PowerPoint, and then exporting a PDF from PowerPoint. The PDFs created by PowerPoint have (I don't know why, maybe some hidden settings) a better resolution than the ones exported from Excel.
I use Xltoolbox , but also we can use IrfanView a free program https://www.irfanview.com/ for converting many photo . You can convert images between different formats, also batch crop, change size, set dpi, change color depth and more. From file menu chose batch conversion,rename/advanced/set new dpi and set it to 300 or more. As shewn in the following screenshots
Also, we can use IrfanView for one image. You can use the following sequence, from file menu , open file, from image menu select resize/re-sample change dpi as you need. As shown in the following screenshots
After reading the comments here, I experimented within Excel and obtained sufficient quality. You could export a manually selected region including your chart as a pdf with the standard publishing option. Then, you need to crop the pdf using a vector graphics package (Inkscape). You would see you don't actually need to use any of the external software mentioned under this post.
After reading here, without installing anything, I have found how obtain a .tiff file with at least 300dpi:
Copy and paste the graph in PowerPoint (in a page (large))
- You make PDF
- Save the PDF with "save as another..", choose image and TIFF, there, there are settings, including resolution which you can change: with 118.11 pixels/cm it has come out just right (300 dpi), but you can put much more
I would follow Sarah Ebert advise however Acrobat Reader in Windows usually does not have funcionality as in MacOS (save as BMP/TIFF/JPEG etc.). For this purpose I use PaperPort but it's not cost effective.
I do not see any chance in MS products to save as bit map (forget about any resolution setting).
In LibreOffice there is a good exporting tool for charts into JPG/PNG raster formats. Brief instructions:
a) select a chart (created in the working sheet) you want to save in JPG/PNG.
b) Go to FIle -> Export -> Check box "Selection" -> Select a format -> Press "Save" button -> Modify resolution to 300 dpi -> Modify WIdth or Height -> Change to minimum compression (highest quality) -> Press "OK" button.
Final result: JPG/PNG image with 300 dpi resolution.
In the first step you should save your Excel graph as a PDF file.
then, import the mentioned PDF file in the Photoshop program and set the resolution on 300 Pixels/Inch and finally save it as Jpg, Bmp or any other formats you need.