Microsoft KB Archive/215318

= XL2000: Chart Title In Interactive Web Page Does Not Appear As Expected =

Article ID: 215318

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:  Start Excel, and then create the following worksheet:

A1: 1

 Select cell A1, and then click Chart Wizard. Accept the defaults, and then click Finish. In cell A5, type Test Chart . Click the chart to select it. On the Chart menu, click Chart Options. On the Titles tab, in the Chart title box, type Title Here, and then click OK.</li> Select Title Here on the chart.</li> In the formula bar, type the following equation

=Sheet1!$A$5

and then press ENTER.

Note that "Title Here" is replace with "Test Chart".</li> On the File menu, click Save as Web Page.</li> Click Publish.</li> Under Viewing options, click to select the Add interactivity with check box.</li> 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".</li></ol>

<div class="workaround_section">

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: <ol> Start Excel, and then create the following worksheet:

A1: 1

</li> Select cell A1, and then click Chart Wizard.</li> Accept the defaults, and then click Finish.</li> Click the chart to select it.</li> On the Chart menu, click Chart Options.</li> On the Titles tab, in the Chart title box, type Title Here, and then click OK.</li> On the File menu, click Save as Web Page.</li> Click Publish.</li> Under Viewing options, click to select the Add interactivity with check box.</li> <li>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.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbbug kbpending KB215318

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.