Results 1 to 2 of 2
2006-12-08, 04:38 #1
- Join Date
- Nov 2004
- Thanked 0 Times in 0 Posts
insert XL chart as transparent picture (any)
In XL i have a chart (XY scatter). I use copy and Paste Special - as Picture to insert into my Word document because I have had trouble with linked files. The background appears white (or sometimes off-white); the file size blows out enormously; and it takes forever to print. I think it's because the background has been imported as white, rather than transparent. The "set transparent' button is greyed out. Is there some better way of doing this?
2006-12-08, 05:52 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
Re: insert XL chart as transparent picture (any)
<P ID="edit" class=small>(Edited by macropod on 08-Dec-06 15:52. Added comment re plot area)</P>Hi Ruth,
. select the chart
. use Format|Selected Chart Area|Patters and set the area fill to 'None'
. copy the chart
Then, in Word, paste the chart as an enhanced metafile, with or without linking.
If you want to, you can select and format the plot area the same way in Excel before copying & pasting.Cheers,
[MS MVP - Word]