software

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: www.excelforum.com/member.php...oamp;userid=21641
View this thread: www.excelforum.com/showthread...hreadid=498338I'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

quot;mcarringtonquot; wrote:

gt;
gt; Hi,
gt;
gt; I insert excel charts into publisher using the insert object command.
gt; It allows me to double click on the chart and modify it in excel even
gt; though it has been pasted in publisher. I have two problems with this.
gt; The first is that I am drastically shrinking the charts and when I try
gt; to modify them in excel they often become distorted. The second problem
gt; I have is that I would like to shrink the chart before inserting it into
gt; publisher. Is there a way to do this while also shrinking the
gt; background? Now I just end up with a small chart, but tons of blank
gt; space around it that gets inserted as well. Any ideas?
gt;
gt; Thanks!
gt;
gt; Megan
gt;
gt;
gt; --
gt; mcarrington
gt; ------------------------------------------------------------------------
gt; mcarrington's Profile: www.excelforum.com/member.php...oamp;userid=21641
gt; View this thread: www.excelforum.com/showthread...hreadid=498338
gt;
gt;

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

quot;DDearbornquot; gt; wrote in message
...
gt; I've struggled with the same issue myself. I haven't been able to come up
gt; with a good solution. Sorry I can't give you anything helpful. I see
gt; you've
gt; been waiting for a response for awhile so I thought I'd let you know I've
gt; tried to do the same. I hope someone else has a solution. - D
gt;
gt; quot;mcarringtonquot; wrote:
gt;
gt;gt;
gt;gt; Hi,
gt;gt;
gt;gt; I insert excel charts into publisher using the insert object command.
gt;gt; It allows me to double click on the chart and modify it in excel even
gt;gt; though it has been pasted in publisher. I have two problems with this.
gt;gt; The first is that I am drastically shrinking the charts and when I try
gt;gt; to modify them in excel they often become distorted. The second problem
gt;gt; I have is that I would like to shrink the chart before inserting it into
gt;gt; publisher. Is there a way to do this while also shrinking the
gt;gt; background? Now I just end up with a small chart, but tons of blank
gt;gt; space around it that gets inserted as well. Any ideas?
gt;gt;
gt;gt; Thanks!
gt;gt;
gt;gt; Megan
gt;gt;
gt;gt;
gt;gt; --
gt;gt; mcarrington
gt;gt; ------------------------------------------------------------------------
gt;gt; mcarrington's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=21641
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=498338
gt;gt;
gt;gt;
The way to make the chart the right size in Excel, assuming you're inserting
a chart on its own sheet, is described by Stephanie Krieger:

www.arouet.net/archives/2004/...g_excel_ch.php
www.microsoft.com/atwork/getw...celtoword.mspx

Although Stephanie is sizing the chart to paste into Word, the process is
the same: determine the size you need, figure the margins around the chart
that center it within the page. Now when you copy and paste as an object,
the chart is already sized to fit.

You probably will get even more accurate results if you save and close the
workbook (with the chart as the active sheet), then insert it from the file.
At least with PowerPoint and Word, this is the best way to insert the chart.

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

quot;Bernard Liengmequot; gt; wrote in message
...
gt; Megan,
gt; Do you really need the chart to be updateable? If not make the chart in
gt; Excel and copy and paste as picture
gt;
gt; If you do then make the chart in Excel and copy and paste as a linked
gt; object. Then do the updating in Excel.
gt;
gt; As you both found, opening an Excel worksheet in another application has
gt; serious pitfalls.
gt; best wishes
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;DDearbornquot; gt; wrote in message
gt; ...
gt;gt; I've struggled with the same issue myself. I haven't been able to come
gt;gt; up
gt;gt; with a good solution. Sorry I can't give you anything helpful. I see
gt;gt; you've
gt;gt; been waiting for a response for awhile so I thought I'd let you know I've
gt;gt; tried to do the same. I hope someone else has a solution. - D
gt;gt;
gt;gt; quot;mcarringtonquot; wrote:
gt;gt;
gt;gt;gt;
gt;gt;gt; Hi,
gt;gt;gt;
gt;gt;gt; I insert excel charts into publisher using the insert object command.
gt;gt;gt; It allows me to double click on the chart and modify it in excel even
gt;gt;gt; though it has been pasted in publisher. I have two problems with this.
gt;gt;gt; The first is that I am drastically shrinking the charts and when I try
gt;gt;gt; to modify them in excel they often become distorted. The second problem
gt;gt;gt; I have is that I would like to shrink the chart before inserting it into
gt;gt;gt; publisher. Is there a way to do this while also shrinking the
gt;gt;gt; background? Now I just end up with a small chart, but tons of blank
gt;gt;gt; space around it that gets inserted as well. Any ideas?
gt;gt;gt;
gt;gt;gt; Thanks!
gt;gt;gt;
gt;gt;gt; Megan
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; mcarrington
gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt; mcarrington's Profile:
gt;gt;gt; www.excelforum.com/member.php...oamp;userid=21641
gt;gt;gt; View this thread:
gt;gt;gt; www.excelforum.com/showthread...hreadid=498338
gt;gt;gt;
gt;gt;gt;
gt;
gt;