Column chart Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that you can paste a picture (e.g. a picture of a pen) into the Column
of a Column chart by either simply copying/pasting the picture or as a fill
effect-picture...

The problem I have is that I have a fill effect for the whole chart area,
let's say blue. Now when I replace the columns with my picture there are
white background behind each of the pictures which I would like to be
transparent. I tried every possible way but can't get rid of it. I know it
works as I have a file here which proves it is possible but don't know how.
However, when I paste the picture into PowerPoint for example there is no
white background so it can't be the picture it must be the chart I have to
change.

Any ideas?
 
If you create a transparent background in the graphic file, it will be
maintained in the chart. Do you have a graphic program in which you can
edit the picture?

If not, try pasting the picture onto the worksheet, and select it. On
the picture toolbar there is a Set Transparent Color tool that you can
use to change the background.
 
Debra, many thanks for your response.

I have tried that already but it doesn't work. I don't have a graphic
program but you are right with using the Set Transparent Color tool on the
picture toolbar. I think the problem is with the chart as the background of
the picture is already transparent. I can see that when I copy the picture in
a PowerPoint presentation.
 
Nicole -

If you have Office XP or earlier, you most likely have Microsoft Photo
Editor. You can copy your graphic from the Excel worksheet and in
PhotoEd use Edit > Paste as New Picture. If you have a GIF file, make a
copy of it and open it directly in Photo Editor. PhotoEd has a
transparency tool: set the image's transparent color using this, and
save the file as a GIF. I use this all the time for graphics on my web site.

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