Forum Discussion

gdstorrick's avatar
gdstorrick
Copper Contributor
Nov 13, 2026
Solved

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...
  • Amezingtechsatara's avatar
    Nov 13, 2026

    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.