XL2000: Chart Title In Interactive Web Page Does Not Appear As Expected (215318)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215318

SYMPTOMS

When you create a chart in Microsoft Excel, and you publish the chart as an Interactive Web Page, the title to the chart is replaced with the words "Chart Title."

CAUSE

This behavior can occur when you use a cell reference to create the chart title, as in the following example:
  1. Start Excel, and then create the following worksheet:

    A1: 1

  2. Select cell A1, and then click Chart Wizard.
  3. Accept the defaults, and then click Finish.
  4. In cell A5, type Test Chart.
  5. Click the chart to select it.
  6. On the Chart menu, click Chart Options.
  7. On the Titles tab, in the Chart title box, type Title Here, and then click OK.
  8. Select Title Here on the chart.
  9. In the formula bar, type the following equation

    =Sheet1!$A$5

    and then press ENTER.

    Note that "Title Here" is replace with "Test Chart".
  10. On the File menu, click Save as Web Page.
  11. Click Publish.
  12. Under Viewing options, click to select the Add interactivity with check box.
  13. Click to select the Open published web page in browser check box, and then click Publish. Note that in the Web browser the title has been replaced with "Chart Title".

WORKAROUND

To work around this issue, do not use a cell reference for a chart title when you want to publish a chart as a Web page. To make the correct chart title appear on the chart you want in a published Web, use the steps in the following example:
  1. Start Excel, and then create the following worksheet:

    A1: 1

  2. Select cell A1, and then click Chart Wizard.
  3. Accept the defaults, and then click Finish.
  4. Click the chart to select it.
  5. On the Chart menu, click Chart Options.
  6. On the Titles tab, in the Chart title box, type Title Here, and then click OK.
  7. On the File menu, click Save as Web Page.
  8. Click Publish.
  9. Under Viewing options, click to select the Add interactivity with check box.
  10. Click to select the Open published web page in browser check box, and then click Publish. Note that in the Web browser the chart title appears as expected.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbpending KB215318
©2003 Microsoft Corporation. All rights reserved.