I have 3 charts that I need to paste into PowerPoint. The first one went in just fine. Whenever I try to paste the other two, the formatting changes. I’m LOOKING at horizontal text alignment on the x-axis, but when I copy/ paste it, it turns slanted. I tried all of the Paste Special Picture, Bitmap and Chart Object options with the same screwy results. I even tried pasting it into Word and Paint and the same thing happened.
What versions of Excel, Word and PowerPoint are you using? What version of Windows are you using? I know it sounds like two inane questions but without knowing the specific tools you are using, it’s difficult to discern if there are any incompatibility issues that might/might not be at the root of the problem.
It sounds like an auto-fit setting. Excel may be reducing the plot area and changes the text formatting to fit the new size. Even if it looks the same size copying and pasting seems to play around with the various settings of each element.
Try going into the settings for the axis and forcing it to horizontal alignment.
You’re bringing back memories of when I had to do this a few years ago. I’m sorry to say that I forgot what I did to resolve this problem or if I could fix it at all.
I can only suggest a few possible fixes.
Try pasting a picture of the chart into an empty excel page first and see how it turns out. If it succeeds then you might try to copy then paste the successful picture. If it fails like before then you know that the problem is definitely Excels.
Try changing the font to a printer font if its tru-type or change it to tru-type if its a printer font. I remember having to do a font type switch in some procedures I was doing.
Is the chart in its very own Excel page or is it an embedded chart? I remember that whole page charts were easier to work with than charts that were small objects on Excel pages.
Potential quick fix: take a screenshot (Printscreen) and then paste that into PowerPoint. It’s difficult to know exactly what’s going on without knowing more details, as other poster have mentioned, but a screenshot is sometimes the way of last resort.