Megan,
Do you really need the chart to be updateable? If not make the chart in
Excel and copy and paste as picture

If you do then make the chart in Excel and copy and paste as a linked
object. Then do the updating in Excel.

As you both found, opening an Excel worksheet in another application has
serious pitfalls.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DDearborn" wrote in message
...
I've struggled with the same issue myself. I haven't been able to come up
with a good solution. Sorry I can't give you anything helpful. I see
you've
been waiting for a response for awhile so I thought I'd let you know I've
tried to do the same. I hope someone else has a solution. - D

"mcarrington" wrote:


Hi,

I insert excel charts into publisher using the insert object command.
It allows me to double click on the chart and modify it in excel even
though it has been pasted in publisher. I have two problems with this.
The first is that I am drastically shrinking the charts and when I try
to modify them in excel they often become distorted. The second problem
I have is that I would like to shrink the chart before inserting it into
publisher. Is there a way to do this while also shrinking the
background? Now I just end up with a small chart, but tons of blank
space around it that gets inserted as well. Any ideas?

Thanks!

Megan


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile:
http://www.excelforum.com/member.php...o&userid=21641
View this thread:
http://www.excelforum.com/showthread...hreadid=498338