Highlighted

Help with excel-to-Illustrator fonts in charts

Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I've seen posts about this before, but haven't found anything that's fixed it for me. I'm runing OSX 10.15.3, trying to paste copied graphs from Excel (version 16.34) into Illustrator 24.0.3. Whatever font I've used to make a graph in Excel, when I paste it into Illustrator, the text changes from letters to symbols (screenshot below). 

 

I tried a solution I've seen elsewhere, exporting from Excel to a PDF. When I open the PDF in Acrobat, it looks fine, but when I open it in Illustrator, it looks just like in the screenshot below. If I export from Excel into a postscript file, Illustrator opens it and it looks normal. That isn't a great work-around, however, because the imported text isn't in text boxes, so it doesn't make it any easier to edit than the other way.

 

Any thoughts? Why is Illustrator not reading the font the same way that Acrobat and Excel are? 

 

Thanks in advance. 


screenshot.png

Correct answer by dianeth | Community Beginner

Hi, I've been frustrated by this for a long time, but this is the first time I have checked online to see if there was a solution. My workaround has been to convert all fonts in the graph manually to Avenir Next, an OpenType font. Not sure if other OpenType fonts would work. This is readable when I copy and paste the graph to Illustrator. I'm using Illustrator 2020 on a MacBook pro2017 running Catalina, and the most recent version of Excel, whatever that is. But I've had this problem for at least a year, under several other operating systems and versions of Illustrator and Excel.

TOPICS
Bug, Draw and design, Import and export, Print and publish

Views

993

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Help with excel-to-Illustrator fonts in charts

Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I've seen posts about this before, but haven't found anything that's fixed it for me. I'm runing OSX 10.15.3, trying to paste copied graphs from Excel (version 16.34) into Illustrator 24.0.3. Whatever font I've used to make a graph in Excel, when I paste it into Illustrator, the text changes from letters to symbols (screenshot below). 

 

I tried a solution I've seen elsewhere, exporting from Excel to a PDF. When I open the PDF in Acrobat, it looks fine, but when I open it in Illustrator, it looks just like in the screenshot below. If I export from Excel into a postscript file, Illustrator opens it and it looks normal. That isn't a great work-around, however, because the imported text isn't in text boxes, so it doesn't make it any easier to edit than the other way.

 

Any thoughts? Why is Illustrator not reading the font the same way that Acrobat and Excel are? 

 

Thanks in advance. 


screenshot.png

Correct answer by dianeth | Community Beginner

Hi, I've been frustrated by this for a long time, but this is the first time I have checked online to see if there was a solution. My workaround has been to convert all fonts in the graph manually to Avenir Next, an OpenType font. Not sure if other OpenType fonts would work. This is readable when I copy and paste the graph to Illustrator. I'm using Illustrator 2020 on a MacBook pro2017 running Catalina, and the most recent version of Excel, whatever that is. But I've had this problem for at least a year, under several other operating systems and versions of Illustrator and Excel.

TOPICS
Bug, Draw and design, Import and export, Print and publish

Views

994

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 04, 2020 1
Most Valuable Participant ,
Mar 04, 2020

Copy link to clipboard

Copied

Well, the magic of Unicode and OpenType fonts. This typically happens when there is a language mismatch, i.e. the region and language system settings don't line up with the app languages. Start by checking that. In fact I'm pretty sure that if you checked your PDFs you might already find hints at potentially wrong font sub-sets being embedded. The only reason it may work with Postscript is that it gets dumbed down to the standard Western/ Latin encoding on export.

 

Mylenium

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I was hopeful when I read this, but checked the language settings in Excel and they're set to US English...is there a language setting in Illustrator that I can fix? I couldn't find anything. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I was jumping between things at work, but just checked the pdf file and I don't see anything funny. The title and axis labels are a different font, but all are funny when it's opened in Illustrator. It's especially strange that it looks fine in both Excel and Acrobat, but not Illustrator. It makes me think there's some setting somewhere in Illustrator that I'm missing. Probably something simple and obvious to somebody other than me. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Adobe Community Professional ,
Mar 04, 2020

Copy link to clipboard

Copied

Use a different font than Calibri

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 1
Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I tried Arial, Times, and a few others. No luck. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Adobe Community Professional ,
Mar 04, 2020

Copy link to clipboard

Copied

You will have to change the font in Excel before making the PDF or copy/pasting the chart into Illustrator. Is that what you tried or did you try changing the font in AI after the fact?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Explorer ,
Mar 04, 2020

Copy link to clipboard

Copied

I tried changing it in Excel..and then tried changing it in Illustrator just to be sure. Neither worked. Very frustrating. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 04, 2020 0
Community Beginner ,
Apr 06, 2020

Copy link to clipboard

Copied

Hi, I've been frustrated by this for a long time, but this is the first time I have checked online to see if there was a solution. My workaround has been to convert all fonts in the graph manually to Avenir Next, an OpenType font. Not sure if other OpenType fonts would work. This is readable when I copy and paste the graph to Illustrator. I'm using Illustrator 2020 on a MacBook pro2017 running Catalina, and the most recent version of Excel, whatever that is. But I've had this problem for at least a year, under several other operating systems and versions of Illustrator and Excel.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 1
Explorer ,
Apr 06, 2020

Copy link to clipboard

Copied

Do you convert to that font in Excel, or after copying into Illustrator? 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 0
Community Beginner ,
Apr 06, 2020

Copy link to clipboard

Copied

I do it in Excel, in the graph. It's tedious, especially if I have a bunch of graphs to spruce up for publication. I'd love to find a more efficient way.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 0
Adobe Community Professional ,
Apr 06, 2020

Copy link to clipboard

Copied

Do you generate the graphs or are they given to you as an Excel file? Try requesting that whoever does the graphs (if not you) change the default font in their version of Excel to the font you need to use when you change the font.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 0
Explorer ,
Apr 06, 2020

Copy link to clipboard

Copied

This worked for me. Thank you! Not a perfect solution, but certainly better than dealing with the gibberish that was coming into Excel using every other font I tried. 

 

Thank you!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 1
Community Beginner ,
Apr 06, 2020

Copy link to clipboard

Copied

Great! And as the previous poster mentioned, if you an somehow manage to get people to create the Excel files in fonts that work, that's a bonus! 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 06, 2020 0
New Here ,
Apr 16, 2020

Copy link to clipboard

Copied

Hi, 
I see your problem is solved, but it might be interesting to mention there is another way to approach this: make you charts in Illustrator using the Datylon Graph plug-in. Just upload or copy the data from Excel, not the graph itself, and build the graph in Illustrator with numerous styling options and using all the fonts you like. You can also create templates which allow you to re-use your charts by simply uploading new data. 
See datylon.com/graph.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 16, 2020 0
gia@IOOF LATEST
New Here ,
Jul 29, 2020

Copy link to clipboard

Copied

Brilliant, thank you, changing the font to Avenir works. That has been annoying me so much. This is a time saver. Thank you.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 29, 2020 0