Thread: Background picture behind chart

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

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

Yes, I tried it and it works
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andy Pope" <andy@andypope.info> wrote in message
news:eqk4E3v6FHA.472@TK2MSFTNGP15.phx.gbl...
> 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

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
>

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

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