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" wrote in message
...
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