Background picture behind chart

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

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