Home

copy as picture changing formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-734407%22%20slang%3D%22en-US%22%3Ecopy%20as%20picture%20changing%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-734407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121914iC98C6C4B11B9CAE1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22as%20seen%20after%20copy%20as%20picture.PNG%22%20title%3D%22as%20seen%20after%20copy%20as%20picture.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eas%20seen%20after%20%22copy%20as%20picture%22%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20856px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121913iC2E545553DA33FB9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22as%20seen%20in%20excel.PNG%22%20title%3D%22as%20seen%20in%20excel.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eas%20seen%20in%20excel%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noticed%20that%20using%20the%20copy%20as%20picture%20function%20in%20excel%20changes%20the%20formatting%20when%20you%20then%20paste%20in%20the%20picture.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20bar%20chart%20with%20some%20data%20labels%20and%20for%20some%20of%20the%20bars%20the%20text%20doesn't%20fit%20in%20one%20line%20so%20I%20have%20resized%20that%20individual%20label%20to%20be%20taller%20and%20allow%20two%20lines%20of%20text.%20However%2C%20when%20I%20%22copy%20as%20a%20picture%22%2C%20despite%20selecting%20the%20appearance%20%22as%20shown%20on%20screen%22%20it%20changes%20the%20formatting%20of%20that%20label%20back%20to%20one%20line%20meaning%20it%20doesn't%20fit%20within%20the%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20some%20images%20showing%20an%20example%20of%20the%20problem.%20So%20far%20the%20only%20sure-fire%20method%20I%20have%20found%20for%20getting%20the%20image%20exactly%20as%20I%20see%20it%20on%20the%20screen%20is%20using%20snipping%20tool%20but%20I%20want%20a%20standard%20process%20I%20can%20use%20to%20create%20images%20of%20the%20same%20size%20every%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-734407%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
AndyGKing
Occasional Visitor

as seen after copy as picture.PNGas seen after "copy as picture"as seen in excel.PNGas seen in excel

 

Hello all,

 

I have noticed that using the copy as picture function in excel changes the formatting when you then paste in the picture.

 

I have a bar chart with some data labels and for some of the bars the text doesn't fit in one line so I have resized that individual label to be taller and allow two lines of text. However, when I "copy as a picture", despite selecting the appearance "as shown on screen" it changes the formatting of that label back to one line meaning it doesn't fit within the box.

 

I have attached some images showing an example of the problem. So far the only sure-fire method I have found for getting the image exactly as I see it on the screen is using snipping tool but I want a standard process I can use to create images of the same size every time.

 

Thanks

1 Reply
WHat happens if you take the picture using the Camera tool? (right-click QAT, choose Customize Quick Access Toolbar, from "Choose commands from", select "Commands not in the ribbon". Then select the area you want a picture from and click the camera button.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies