Im having a bit of a problem with the text from charts made in Excel 2008 (v.12) copy and pasted into Illustrator CS6
Once pasted into Illustrator it changes all the text pasted into numbers and punctuation marks
I cant see in the setting anything to change with fill handling etc to stop this happening
I need to paste these charts into Illustrator from excel to make them into into house styles etc as they are supplied to me and illustrator cant make up the charts I need.
Any ideas anyone as I dont want to have to retype the text on each chart if I can help it.
You are on a Mac, correct? If this is the case then in Excel before copying the chart, right-click and choose Format Chart Area. Select the Fonts from the field at the left of the resulting dialog and change the font in the dropdown list from Calibri (Theme Body) to Ariel or some other font that you have on your machine. Then copy and paste into AI.
thank you so much for your help it worked like magic
Yes i am on a mac
Is there a way to set the chart text as Arial as default rather than calibri do you know?
from what I can see I can change the main text to be arial but the chart still comes out as calibri in Excel regardless
Thanks again for your help really appreciated
Hi guys, there are several way to approach the font change. The font is picked up from the default "Body Font" on the default "Office Theme" template when creating new documents.
to change the font to Arial or something else (using Windows), go to File->Options->General and choose your font under "When creating new Workbooks"
that would make "Arial" the default font when typing your data in new books, but when the chart is made, it will still have "Calibri" in it since we're using the default "Office Theme".
to change the font, go to "Page Layout" tab and in the "Themes Group", click on "Fonts" and at the bottom click on "Create New Theme Fonts"
change the Body Font to "Arial", give the Theme font a name and click Ok.
now all newly created books will show Arial, but the charts will still have the Calibri font since they depend on the "Office Theme" template, but now it will be easier to change the theme fonts to the Arial, by choosing the newly created theme, and the charts will pick up the fonts too.
it is possible to change the default "Office" theme to something else...but that's another tutorial.
Europe, Middle East and Africa