Background picture behind chart

[Guest]

In Excel I have successfully inserted a picture behind an interactive chart
so the chart (graph) is visible overtop of the picture. But when I Save as
Web Page the picture doesn't show up. The graph is fine, and is interactive,
but the background picture file (gif) has disappeared. How can I preserve
the picture so it will save as part of the Web Page? Thanks.

Ralph

 

[Andy Pope]

Hi,

Not tested but could you use the picture as the Fill Special for the
chart or plot area?

Cheers
Andy

 

[Bernard Liengme]

Yes, I tried it and it works

 

[Guest]

Yes, that is what I did, and the picture shows up just fine in the background
with the chart in the foreground as long as I'm in Excel. The problem occurs
when I Save as Web Page. The resulting html file does not show the picture,
just the chart.

 

[Andy Pope]

My suggestion, which Bernard confirmed (thanks!), is to use the picture
as the fill for the chart area.
Your description was that the image was a separate object from the chart
and it didn't survive the journey to html.

Did you use the fill approach?

 

[Jon Peltier]

Some instructions might help.

Double click on the chart area of the chart (the big enclosing
rectangle. On the Patterns tab, click on the Fill Effects button. Select
the Picture tab, click the Select Picture button, and browse to the
picture to use as the chart background.

Then double click on the plot area, and choose no line and no fill, so
it doesn't obscure the background picture.

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

 

[Guest]

Thanks Jon. I've done exactly what you suggested and yes it works and looks
great. But the problem occurs when I Save to Web Page. When I open the
saved html file in MSIE the background picture is not visible...only the
chart is. You see, I would like to add this interactive chart with
background picture to my web site but no luck so far.

Ralph

 

[Jon Peltier]

Well, I don't know about the Save As Web Page. I never use it, because I
found the old version unpredictable and kludgy. This VBA command exports
a chart to an image file, complete with background image:

ActiveChart.Export "C:\test\PicBkd.png", "png"

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