Illustration 1: To run the interactive spreadsheet, the browser you are using now must
have Internet Explorer 4.01 or higher according to Microsoft
Corporation. However, some people around the world are telling me that
they cannot run these illustrations unless they have upgraded to Office 2000
with at least the Internet Explorer 5.00 or higher that comes with the
Office 2000 upgrade. A few people with IE 5.00 and 5.01 stand alones
with having the Office 2000 upgrades reported problems in having the
spreadsheets appear in Illustrations 1-4. If
you see a spreadsheet in Illustration 1, you can test for interaction
in by
entering new data in Cells B11, B12, and/or B13.
Click here to view the Illustration 1 interactive spreadsheet.
Illustration 4: To
show how to hide and show interactive chart layers (authored in Macromedia
Dreamweaver). This illustrates how to make up, in part, for not having
Excel macro functionality and attached buttons that will run macros
transport to HTML documents. After saving the Excel spreadsheets
and charts into a master HTML file, I imported that file into Macromedia
Dreamweaver. I then formed three hide/show layers, added behavior
buttons, and pasted the illustrations into their respective layers. I
do not know how to create hide/show layers in FrontPage 2000 without having
to write raw code in JavaScript or VBscript. Dreamweaver inserts the
layer coding automatically. Click here to view
the Illustration 4 interactive charts. (This
page opens in a new window.)
Click here to view the instructions on how to
save an Excel spreadsheet as an interactive (dynamic) HTML document.
Illustration 1 on Saving an Excel Workbook
as a Dynamic (Interactive) HTML File
Example
Test for
interaction by entering new data in Cells B11, B12, and/or B13.
Test for
interaction by entering new data in Cells B11, B12, and/or B13.
Illustration 2 on Saving an
Excel
Chart as an Interactive HTML file
You must save (publish) each chart as a separate HTML file, and when you
save a workbook it does not automatically save any chart. You can,
however, create a new (master) HTML file and then copy in the Excel
workbook and copy in each chart to the master HTML file.
When you save a chart, it will add a spreadsheet, but the spreadsheet will
only include the data range that pertains to the chart. It will not
include cells that are outside the chart's data range.
If you have some cells that you would like included in the chart's
spreadsheet, you should add rows and columns within the chart's data
range. For example, in Illustration 2 below, the column for
"Gender" was not originally in the chart that I created.
When I discovered that this column did not appear in the chart's
spreadsheet, I added a blank column between the listing of the student name
column and the examination score column. Then I copied the
"Gender" column between the student names and their examination
scores. When I saved the chart below, it then included all three
columns in the chart's spreadsheet even though the "Gender" column
data was never declared in the chart's data range.
If you create macros, I cannot find any way to get them to run in the HTML
file. For example, the macro hot keys do not work. If you attach
a macro to a button, the button will not appear in the HTML file. For
example, in this simple illustration, the Excel workbook has two macros
called the "Female" and "Male." I then created the
macros and attached them to buttons on the Excel spreadsheet such that if
you clicked on the "Male" button, the macro filled the blue data
into the spreadsheet shown below. It also created the blue bar chart
shown below and created the blue text box in the chart. When I
clicked in the "Female" button, the "Female" macro
replaced all the male names, gender, and examination scores with female data
that appeared in red instead of blue. The text box also changed to red
and the contents of the text box in the chart then read "Female
Gender" in red. Unfortunately, the macro buttons in the Excel
chart will not get saved in the HTML version and the macros will not
run. I cannot change the data below into female data with the Female
macro.
A text box that reads "Male Gender" in blue
that was attached
to the original Excel chart did not get transferred into the HTML version of the
chart below. Hence, any text that you read must be part of the charts Title,
axes labels, or legend box. You cannot transfer text from a text box
that you added to the Excel chart.
I cannot get any attached objects such as
buttons, arrows, and text boxes to transfer to the HTML version.
Note that you can change the names, gender, and examination score data
below. The chart will change accordingly
on-the-fly as you change the name and examination scores.
The Gender data was never part of the chart itself.
Note that you can change the names, gender, and examination score data
above. Try it by typing in new names. The chart will change accordingly
on-the-fly as you change the name and examination scores.
The Gender data was never part of the chart itself.
Illustration
3 Showing a Multiple Chart Problem That I Accidentally Resolved
Note in the chart below that the contents of the
chart do appear. It took several times to make the red bars appear.
I don't know why, but the bars would not appear until I started typing this
paragraph above the chart. Then the bars suddenly appeared. Wierd!
Illustration 4 Showing How to Hide and Show
Interactive Chart Layers
Illustration 4: To
show how to hide and show interactive chart layers (authored in Macromedia
Dreamweaver). This illustrates how to make up, in part, for not having
Excel macro functionality and attached buttons that will run macros
transport to HTML documents. After saving the Excel spreadsheets
and charts into a master HTML file, I imported that file into Macromedia
Dreamweaver. I then formed three hide/show layers, added behavior buttons,
and pasted the illustrations into their respective layers. I do not know
how to create hide/show layers in FrontPage 2000 without having to write raw
code in JavaScript or VBscript. Dreamweaver inserts the layer coding
automatically. Click here to view
the Illustration 4 interactive charts. (This
page opens in a new window.)
Instructions on how to save an
Excel spreadsheet as a dynamic (interactive) HTML document.
Note from Jensen: I prefer to follow the steps below to
create a dynamic (interactive) spreadsheet HTML file. Then I insert that
file within a file using the following steps:
Click on (Edit, Select all) and copy the entire dynamic
spreadsheet file to the clipboard.
Go to an existing HTML file and find an insertion point
within your existing text.
Paste the dynamic spreadsheet into the HTML document.
If you follow these steps, you do not have add all the
header information to the original dynamic spreadsheet file.
The following general instructions are given in the Excel 2000 Help pages:
Click the chart or the chart sheet that you want to put on a Web page.
On the File menu, click Save as Web Page.
Click Publish.
Under Viewing options, select the Add interactivity with check box. (Chart
functionality is automatically selected.)
To add a title to the published chart, click Change, type the title you want,
and click OK.
In the File name box, click Browse, and locate the drive, folder, Web folder,
Web server, or FTP location where you want to save or publish your Web page.
If you want to view the Web page in your browser after you publish it, select
the Open published Web page in browser check box.
Click Publish. Notes
The associated data for the chart is also placed on the Web page when you use
interactive functionality. When you save a chart, an associated interactive
spreadsheet is included, and when you save a PivotChart report, an associated
PivotTable list is included.
Some formatting and features for your chart are not retained when you save it
as a Web page.
You can learn more about publishing charts.
After you save your chart as a Web page, you can't open and modify the .htm
file in Microsoft Excel without losing formatting and functionality. Use
Microsoft FrontPage 2000 or data access page Design view in Microsoft Access
2000 to modify the Web page.