0

Using Excel for Mac 16.40 & Illustrator 24.2.3, when I copy a graph from Excel to Illustrator, all the text corrupts:

enter image description here

The text font is Arial.

It would be so nice if Excel graph text copied and pasted into Illustrator without being corrupted.

Is it possible to copy/paste/import Excel graphs into Illustrator with the text being retained?

Help appreciated.

2
  • I don't have Mac, but you can try to copy as a picture. Pasted image probably (like in Windows system) contains a ton of multilevel groupings and clipping masks. (=much to release and delete before you can make edits) Also texts can become drawings which with no hinting can look awful. I guess you must rewrite the texts. I have found that regenerating the graph from the same data in 20 years old Excel generates much simpler vector images when copied and pasted to Illustrator. – user287001 Aug 13 '20 at 10:26
  • Select the text objects and reset the font in AI. – Scott Jan 10 at 19:13
1

I found an easy solution to this! Copy and paste the graph into InDesign first. Then Cmd + C + Ragain from InDesign and paste into Illustrator.

The graph will have all the correct text and is fully editable.

2
  • you are brilliant dude! Indesign workaround like a charm!!!! – Kevin Huewan Feb 15 at 10:08
  • Works like a charm. – MG_ Feb 15 at 11:39
0

It has something to do with the way that Microsoft encodes their text. I think it's intentionally done to corrupt it sometimes.

The easiest way I have found around it is the save the Excel graph out as a PDF. Open the PDF in Acrobat, save as an EPS (Encapsulated PostScript) file, and have the settings set to convert fonts to outlines.

Unfortunately, it doesn't look like that is an option anymore for some reason, at least not in my Acrobat DC. I did find this blog post that goes over a new way to do it, tedious, but still effective. convert to outlines in illustrator

Otherwise, to my knowledge, there really isn't an easy fix for it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.