Forum Discussion
moonshot
Oct 27, 2024Copper Contributor
Printing excel chart in high quality
Hello, I'm new here and I need help. I have a very important meeting at my company on Tuesday which can possibly give me the promotion that I have been waiting for. The thing is our CEO is goin...
asunkindheal
Oct 27, 2024Copper Contributor
I understand you don't want to leave any stone unturned so I guess you wouldn't mind learning a bit about how printing works.
First thing you need to understand is, to get crisp and clear print, you need a high resolution file.
I think by trying all the methods you are failing particularly at this and this only—saving the chart at enough resolution to print it at high quality on your paper.
So first you need to determine the minimum resolution your image file should be to print it at high quality, which depends on the size of your paper.
The most common paper that we all use in our offices is the letter. I am considering you are also using the same paper. If not, you need to find the size of the paper you are using in inch.
So the size of the letter paper is 8.5in x 11in. Now you can use any calculator that gives you pixel size from inch for printing at 300 DPI (setting DPI at 300 is important for high quality) - https://cssunitconverter.com/inches-to-pixels/
So to print on 8.5in x 11in paper, you need your image file to be of at least 2550 x 3300 pixels. Higher resolution than this is good but lower resolution than this mean compromised print quality.
Once you have the image file of this size you need to ensure that your printer settings are configured in right way. Make sure to print at the highest DPI (Dots Per Inch) settings your printer supports.
So this is how you can get the highest quality print that you are looking for.
First thing you need to understand is, to get crisp and clear print, you need a high resolution file.
I think by trying all the methods you are failing particularly at this and this only—saving the chart at enough resolution to print it at high quality on your paper.
So first you need to determine the minimum resolution your image file should be to print it at high quality, which depends on the size of your paper.
The most common paper that we all use in our offices is the letter. I am considering you are also using the same paper. If not, you need to find the size of the paper you are using in inch.
So the size of the letter paper is 8.5in x 11in. Now you can use any calculator that gives you pixel size from inch for printing at 300 DPI (setting DPI at 300 is important for high quality) - https://cssunitconverter.com/inches-to-pixels/
So to print on 8.5in x 11in paper, you need your image file to be of at least 2550 x 3300 pixels. Higher resolution than this is good but lower resolution than this mean compromised print quality.
Once you have the image file of this size you need to ensure that your printer settings are configured in right way. Make sure to print at the highest DPI (Dots Per Inch) settings your printer supports.
So this is how you can get the highest quality print that you are looking for.
moonshot
Oct 28, 2024Copper Contributor
Thanks. This was helpful. I am using A4 size paper 150GSM silk coated. I got paper size in inch from internet as you said, which is 8.27 diagonally x 11.69 vertically so I put that in converter and got 2481 x 3507 resolution.
I tried a lot but couldn't get that resolution image from excel so at last I uploaded my sheet to canva and created the graph there of the required size.
Tomorrow at the office I will print the reports.
I tried a lot but couldn't get that resolution image from excel so at last I uploaded my sheet to canva and created the graph there of the required size.
Tomorrow at the office I will print the reports.
- asunkindhealOct 28, 2024Copper ContributorHappy to help and good luck for your meeting 👍