I'm trying to import some labelled pie charts I made, in Excel 2011, into AI CS5. I want to edit the art and text in Illustrator (vectors, natch). The pies and lines come in just fine, but the text is garbled.
If I do any of the following, the text from Excel comes in as garbled, scrambled gibberish:
Have you ever solved this problem, or a similar one?
Do you have any ideas that might help me?
Change the font used in the Excel chart to something else on your machine. Right-click on the chart and select Format Chart Area. Go to the Font atb (at the bottom) and change it from Calibri (Theme Body) [Or whaterver it says] to something like Arial. Then recopy and paste the chart.
Bless ye, sir. That did the trick!
Weird, because I have that font (yep, it's Calibri) and I can choose it and use it in AI... but I changed Calibri to Arial in Excel, as you suggest, and I'm able to paste from Excel.
Thanks very much!