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/
_______


RalphB wrote:

> 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" wrote:
>
>
>>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/
>>_______
>>
>>
>>Andy Pope wrote:
>>
>>
>>>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?
>>>
>>>RalphB wrote:
>>>
>>>
>>>>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" wrote:
>>>>
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>Not tested but could you use the picture as the Fill Special for the
>>>>>chart or plot area?
>>>>>
>>>>>Cheers
>>>>>Andy
>>>>>
>>>>>RalphB wrote:
>>>>>
>>>>>
>>>>>>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, Microsoft MVP - Excel
>>>>>http://www.andypope.info
>>>>>
>>>