MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Trying to save Excel sheet as web page


Posted by Christopher Patrick on October 24, 2001 1:06 PM

Hi all-

I wonder if anyone can help. I have an excel sheet in Office 2000 which contains several graphs. I want to create a web page of this sheet (graphs and all) for the web. When I attempt to do so, I click File->Save as Web Page...then select the sheet option....the web page is created, but no graphs are visible, or only the source/series of the graph data is visible. Is there something I am doing wrong?

Thanks for any help.

Chris


Posted by Mark W. on October 24, 2001 1:21 PM

Can't you locate a folder (e.g., Page_files)
in the same directory as your .htm file (e.g.,
Page.htm) that contains GIF files for each of
your charts?

Posted by Christopher Patrick on October 25, 2001 8:03 AM

Hi again-

The folder is there, contains the images, but the web page still appears with no images, or the text of the chart source data.


Posted by Mark W. on October 25, 2001 8:40 AM

Chistopher, what's the Chart Location of these
charts (take a look at the Chart | Location...
menu command). I believe that the charts must
be imbedded into a worksheet (i.e., listed "As
object in"). Did you put them on separate
chart sheets or are they embedded?


Posted by Mark W. on October 25, 2001 8:41 AM

Sorry, I really can spell "Christopher" (nt)