XL2000: Scatter Chart Points and Line Missing When Published as WebPage with Interactivity

ID: Q230945

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

The chart data points and line may be missing from an XY (Scatter) chart that you publish as a Web page.

CAUSE

This problem occurs when the following conditions are true:

You create an XY (Scatter) chart with only one row or column of values.

-and-

You publish the chart as a Web page with interactivity.

-and-

You open and view the resulting published Web page chart in Excel or a Web browser.

This behavior is by design of Microsoft Excel.

WORKAROUND

To work around this problem, use either of the following methods.

Method 1: Use Two Series

When you want to save an XY (Scatter) chart as a Web page with interactivity, always use two series, even if the x values are 1, 2, 3, and so on.

Method 2: Use a Line Chart

With the one series of data selected, make the chart a line chart, which will appear the same as the XY (Scatter) chart.

MORE INFORMATION

In an XY (Scatter) chart, if you do not specify x values, Excel will provide generic values for you (1, 2, 3, and so on). This behavior is automatic in Excel. However, when Excel publishes a Web chart with interactivity, it does not save the generic x values. The Web chart does not support generic data, and so will not draw a series unless all of the data dimensions are specified. Because there are no x values, it therefore cannot draw the series data points and line.

REFERENCES

For more information about how to put a chart with interactivity on a Web page, click Microsoft Excel Help on the Help menu, type "Put a chart on a Web page" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: XL2000

Keywords : kbchart
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb