Hi, sorry to bother you.
When I save the current sheet to the web then both the cells and the chart
get published and there IS a subfolder where the chart image is stored. The
..htm file that gets created also has a special icon beside it in the windows
explorer folder listing which is a combination of the Excel & IE icons.
When I save the entire workbook as a web page then the subfolder is not
created and the .htm that is created has only a simple IE icon beside it in
the windows explorer folder list. The contents of the .htm file seem to be
almost entirely XML code.
So it seems that saving the entire workbook has special behavious that
doesn't allow displaying of charts. Or I don't know how to enable this
functionality.
thx
"Earl Kiosterud" wrote:
Mac,
Graphics, such as the charts, appear in a folder that must be published
along with the htm file. Could that be the problem? The folder's name is
based on the name of the htm file. If it's MyWorkbook.htm, then you'll see
a folder with a name like "MyWorkbook_files." You might want to save the
file to a local folder first, then open it with your browser (just
double-click it from the folder it lives in) to make sure that's working
before you get into the publishing to your web server part.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"macroplay" wrote in message
...
sorry, I'm running Windows XP and Excel 2002 SP3.
"Earl Kiosterud" wrote:
Mac,
You don't say which version of Excel you're using, but I recall that
Excel97
behaved the way you're describing. Excel 2002 puts the chart in the htm
file, actually like it should. Where it belongs. Don't recall about
Excel
2000 or 2003.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"macroplay" wrote in message
...
I have a multi-sheet workbook in which each sheet represents another day
with
some data in the cells and a chart produced from this data and located
on
the
day's sheet where the data is.
The problem is when I "Save as Web Page" the entire workbook, all the
sheets
and the cell data appear in the IE browser but the charts on each sheet
do
not.
Is there a way to have the charts also appear on the web page along
with
the
sheet data for that day ?
thx