Quickly Import Excel Graphs in Illustrator

[@janyamarkevich1652]

Some people are just there to genuinely help. Thank you so much for such a concise explanation!

[@IlliTutorials]

Thanks for the comment! One of the best things about this platform is the chance to make other people's lives/work a bit easier! Also, I do this so often that I figured I couldn't be the only one!

[@obrapro]

Perfect video. Short to the point, no crap voice-over. THX!

[@IlliTutorials]

Glad it helped!

[@knast7093]

Amazing! Such smooth and precise explanation - Thank you so much!

[@echoloud1230]

JUST AWESOME! I'm a subscriber! Thank YOU so much!

[@user-bn8bc5bb5x]

You have saved my life. THANK YOU

[@thaisherrera3827]

Hi, great tutorial! it didn't quite work for me though, when I paste it I get an error message and then it just gives me an uneditable raster image... help

[@TheBlackWhite88]

Just what I needed, wish I saw your video earlier. Thanks!

[@IlliTutorials]

Glad it was helpful!

[@lorenarobles790]

You just made my life a little bit better with this tutorial :D

[@IlliTutorials]

I'm happy to hear!

[@TiMENekoCafeTiME]

This is great! But what about a trendline? It doesn't get imported and especially if it's non-linear trendline...

[@mariabeatasanchez2509]

So brief and very helpful! Thank you so much!!

[@IlliTutorials]

Glad it was helpful!

[@wagnersantos7748]

Is there any specific course on how to edit graphs in illustrator?

[@demiancoorey2394]

worked for me!

[@davidleiderman1329]

When I have to release the option is in grey so I can’t click on it. It was after doing ctrl + alt + 7 two times.

[@gellayo9885]

So helpful. Thanx a lot!

[@IlliTutorials]

Glad it was helpful!

[@welshmountain1330]

For some reason, this does not always work. I am working on a project which brings charts from Excel to Illustrator for ID. Some charts will import without complications, while others only import as a photo. There is no compound path or clipping mask involved. I have also tried to place the charts into PowerPoint, export to svg or eps, and that will not work. When I finally have it imported, the text is all outlines and needs to all be retyped. It's become a full day's work just for the chart conversion to Illustrator, which annoys.

[@Stashdragon]

So I deal with a lot of excel graphs made in China and when I try and copy, paste into Ai, it does not bring everything over. Sometimes the lines in the middle of the graph are missing, sometimes, it's words, it varies. Excel also makes it really hard to select multiple things at once when it comes to a graph. Also I ALWAYS have to change the font in Excel before I move a table because if I don't then all the text just shows up as random characters in Ai. Any help with this issue would be awesome. Thanks for the vid.

[@IlliTutorials]

I assume there are two issues. First, the excel version may be different between your version and theirs. Second, your likely missing the fonts that are used in the Chinese excel charts. I could suggest that you have them send you the excel graphs with the latest version of excel and you could download a common font package for Mandarin.

[@maazyunus]

Wow! Amazing. Thanks man

[@IlliTutorials]

No problem!

[@joycetsuiart]

This was so helpful! Thanks

[@IlliTutorials]

Glad it was helpful!

[@innaklein1834]

Hi can we change the graph by changing the data in illustrator

[@IlliTutorials]

Illustrator does have a graph tool that you can use to make graphs. But with an imported graph from Excel, no, everything is done manually.

[@gnyaneswarankarboina7725]

Good one, but can you remove the barriers (censors) in a KM graph or curve without affecting the curve ?

[@IlliTutorials]

I'm sorry, but I'm not sure what a KM graph is.

[@graphicbrew]

Remove the borders in Excel before copy/pasting into Excel ;)

[@IlliTutorials]

Yeah, that's also an option.

[@seastar32]

It’s not so simple. Sometimes illustrator can’t paste text. Sometimes problem with gradients. Etc.

[@IlliTutorials]

Yes, it can get complicated depending on the graphs. But for simple scatter charts, quickly made, they can be imported and spruced up with this method.

[@clintblack6070]

Now do this for 150 odd graphs

[@IlliTutorials]

In that case, make the graphs in R, save as SVG and import them that way.