How do I bring Excel graph to illustrator (no cut and paste)

I am using Excel 2003 and Illustrator 9.0, how do I bring in a chart (like a
2D surface chart) from Excel into Illustrator, so that it can be edited in
illustrator (so that it is not just an image)? Cutting and pasting is not
working.

I take it this can't be done?

"Excel_lent" wrote:

> I am using Excel 2003 and Illustrator 9.0, how do I bring in a chart (like a
> 2D surface chart) from Excel into Illustrator, so that it can be edited in
> illustrator (so that it is not just an image)? Cutting and pasting is not
> working.

Unless Illustrator understands the concept of an XL chart, wouldn't it
be meaningless to try and keep the XL chart as anything but an image in
it?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> I take it this can't be done?
>
> "Excel_lent" wrote:
>
> > I am using Excel 2003 and Illustrator 9.0, how do I bring in a chart (like a
> > 2D surface chart) from Excel into Illustrator, so that it can be edited in
> > illustrator (so that it is not just an image)? Cutting and pasting is not
> > working.
>

By "edit in Illustrator" and "just a picture", I assume you mean you
want a vector graphic, not a bitmap.

I have no idea how Illustrator works, but here's what I do with target
apps that understand metafiles (i.e., vector images). In Excel I copy
the chart as a picture. I do this by holding Shift when I select the
Edit menu, which changes Copy to Copy Picture. Then I select the On
Screen option(s) and As Picture. Then I go to the target application and
use its native Paste command.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Excel_lent wrote:

> I take it this can't be done?
>
> "Excel_lent" wrote:
>
>
>>I am using Excel 2003 and Illustrator 9.0, how do I bring in a chart (like a
>>2D surface chart) from Excel into Illustrator, so that it can be edited in
>>illustrator (so that it is not just an image)? Cutting and pasting is not
>>working.

Thanks Jon, I didn't know the lingo, but yes, a vector image is what I was
looking for. I'm getting my chart to copy as a picture, but it still will not
paste in Illustrator.

So, I guess the logical alternative would be to save the file as a metafile
(ie vector image), then open it in Illustrator.

Do you know a good way to save Excel charts as Metafiles?

Thanks for your help!

-Louis



"Jon Peltier" wrote:

> By "edit in Illustrator" and "just a picture", I assume you mean you
> want a vector graphic, not a bitmap.
>
> I have no idea how Illustrator works, but here's what I do with target
> apps that understand metafiles (i.e., vector images). In Excel I copy
> the chart as a picture. I do this by holding Shift when I select the
> Edit menu, which changes Copy to Copy Picture. Then I select the On
> Screen option(s) and As Picture. Then I go to the target application and
> use its native Paste command.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Excel_lent wrote:
>
> > I take it this can't be done?
> >
> > "Excel_lent" wrote:
> >
> >
> >>I am using Excel 2003 and Illustrator 9.0, how do I bring in a chart (like a
> >>2D surface chart) from Excel into Illustrator, so that it can be edited in
> >>illustrator (so that it is not just an image)? Cutting and pasting is not
> >>working.
>