Skip navigation
LinksMasterSword
LinksMasterSword Calculating status...
Currently Being Moderated

Chart text from Excel to illustrator cs6 not copying right

Sep 9, 2012 7:05 AM

Hi all

 

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.

 

Many thanks

 

Paul

1679 Views   7 Replies   Latest reply: LinksMasterSword, Sep 11, 2012 12:19 AM
 
Replies
  • Larry G. Schneider
    Currently Being Moderated
    1. Larry G. Schneider,
    Sep 10, 2012 9:09 AM   in reply to LinksMasterSword
    Report

    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.

     
    |
    Mark as:
  • LinksMasterSword
    Currently Being Moderated
    2. LinksMasterSword,
    Sep 10, 2012 9:22 AM   in reply to Larry G. Schneider
    Report

    Hi Larry

     

    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

     

    Paul

     
    |
    Mark as:
  • Larry G. Schneider
    Currently Being Moderated
    3. Larry G. Schneider,
    Sep 10, 2012 9:31 AM   in reply to LinksMasterSword
    Report

    I don't know enough about Excel to know where to change that. I just have to do it all the time myself.

     
    |
    Mark as:
  • LinksMasterSword
    Currently Being Moderated
    4. LinksMasterSword,
    Sep 10, 2012 9:34 AM   in reply to Larry G. Schneider
    Report

    ok - thanks again

     
    |
    Mark as:
  • CarlosCanto
    Currently Being Moderated
    5. CarlosCanto,
    Sep 10, 2012 2:14 PM   in reply to LinksMasterSword
    Report

    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.

    changeFont1.gif

     

    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"

    changeFont5.gif

    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"

    changeFont2.gif

     

    change the Body Font to "Arial", give the Theme font a name and click Ok.

    changeFont3.gif

     

    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.

    changeFont4.gif

     

     

     

    it is possible to change the default "Office" theme to something else...but that's another tutorial.

     
    |
    Mark as:
  • Larry G. Schneider
    Currently Being Moderated
    6. Larry G. Schneider,
    Sep 10, 2012 2:23 PM   in reply to CarlosCanto
    Report

    Thanks, Carlos but most of the stuff I deal with is created by science guys who don't care.

     
    |
    Mark as:
  • LinksMasterSword
    Currently Being Moderated
    7. LinksMasterSword,
    Sep 11, 2012 12:19 AM   in reply to CarlosCanto
    Report

    Thank you so much for that info - will try it today

     

    Cheers

     

    Paul

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points