Forum Discussion
Excel Chart Copy/Paste Resolution
I create charts in Excel, paste them into Photoshop to add a transparent background, then paste these into my web site. I've been doing this since 1999.
Until today, the charts always copy/pasted at 96 dpi. The work flow depended on this. These charts are all sized to fit in the right places. 4" by 5" gave 385 x 481 pixels. They looked good. Hotspots (img maps) on the web page lined up properly with chart elements.
Today they paste at 150 dpi which is too large. 4"x5" becomes 601 x 751 px. Nothing lines up. Reducing the size in Photoshop gives ugly results.
The File>Options>Advanced>Image Size and Quality Default Resolution cannot be changed to 96. It immediately reverts back to High Fidelity. So this idea does not work.
I know that I can start all over, but that is a lot of work.
How do I set the default chart resolution for copy/paste back to 96 dpi where it was for 27 years and where I need it to be?
What did MS change to break this?
Windows 11, Microsoft® Excel® for Microsoft 365 MSO (Version 2610 Build 16.0.20527.20150) 64-bit
You're pulling the wrong lever, I'm afraid — and that's actually useful news, because it points at where the change really happened.
That Default resolution setting under File > Options > Advanced > Image Size and Quality is about pictures you insert into a document, not about what Excel puts on the clipboard when you copy a chart. Microsoft's own write-up on it talks about inserting pictures with minimal compression. So no matter what you set it to, your paste into Photoshop won't change — and the fact that it snaps straight back to High Fidelity when you pick 96 looks like a bug in that build, worth sending in through File > Feedback with your version number attached.
The paste size comes from the screen instead. A plain copy hands Photoshop a picture rendered at your display's DPI, and your numbers give it away: 4 inches coming out at 601 pixels is 150 dpi, not 96. So something on the display side changed — the usual suspects are Windows display scaling (Settings > System > Display > Scale, where 100% is 96 dpi), the Excel window sitting on a different monitor than it used to, or a docking or remote session in between. Nothing in the chart itself changed, which fits with it breaking overnight.
If you want the copy itself under control, select the chart and use Home > Copy > Copy as Picture, and pick 'As shown on screen'. That dialog is the one place Excel lets you choose how the chart is rendered for the clipboard. Get the scaling back to 100% first and re-copy — resampling the oversized image down in Photoshop afterwards is what gives you the ugly results you're seeing.
4 Replies
- gdstorrickCopper Contributor
Thank you Amezingtechsatara.
I knew File > Options > Advanced > Image Size and Quality was a red herring, but it is the overwhelming answer I found in my online searches. I didn't want anyone suggesting that.
Settings > System > Display > Scale, where 100% is 96 dpi has not changed. It has always been that. My six monitors are all identical, and have not changed in years.
Home > Copy > Copy as Picture, and pick 'As shown on screen' works when I copy as a bitmap. Clunky compared to Ctrl-C but not too bad. Thank you!!
And yes, I know that Photoshop down-sampling caused the ugliness. No need to have anyone suggest that I do that.
Thank you again, great answer. - AmezingtechsataraBrass Contributor
You're pulling the wrong lever, I'm afraid — and that's actually useful news, because it points at where the change really happened.
That Default resolution setting under File > Options > Advanced > Image Size and Quality is about pictures you insert into a document, not about what Excel puts on the clipboard when you copy a chart. Microsoft's own write-up on it talks about inserting pictures with minimal compression. So no matter what you set it to, your paste into Photoshop won't change — and the fact that it snaps straight back to High Fidelity when you pick 96 looks like a bug in that build, worth sending in through File > Feedback with your version number attached.
The paste size comes from the screen instead. A plain copy hands Photoshop a picture rendered at your display's DPI, and your numbers give it away: 4 inches coming out at 601 pixels is 150 dpi, not 96. So something on the display side changed — the usual suspects are Windows display scaling (Settings > System > Display > Scale, where 100% is 96 dpi), the Excel window sitting on a different monitor than it used to, or a docking or remote session in between. Nothing in the chart itself changed, which fits with it breaking overnight.
If you want the copy itself under control, select the chart and use Home > Copy > Copy as Picture, and pick 'As shown on screen'. That dialog is the one place Excel lets you choose how the chart is rendered for the clipboard. Get the scaling back to 100% first and re-copy — resampling the oversized image down in Photoshop afterwards is what gives you the ugly results you're seeing.
- william16133Copper Contributor
This sounds like a change in how the newer Microsoft 365 build handles chart rendering during copy/paste. Since your workflow has depended on 96 DPI for so many years, I'd first check whether Excel is copying the chart as a higher-resolution bitmap or as a vector object.
One thing worth testing is pasting the chart into PowerPoint or Word first, then exporting it as an image with the required dimensions. That may help identify whether the issue is Excel's copy process or Photoshop's handling of the pasted image.
Hopefully someone can confirm whether this is an intentional change in the latest Microsoft 365 build or a regression.
- gdstorrickCopper Contributor
william16113:
Good points. The image is going into Photoshop as an RGB Color image when it used to go in as an Indexed Color image. If I follow Amezingtechsatara's suggestion using Home > Copy > Copy as Picture, what it goes in as depends on whether I choose to copy the chart as a picture or as a bitmap. So it is pretty clear that Excel has changed.
Thank you.