Microsoft KB Archive/230945

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

Article ID: 230945

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q230945



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:
 * 1) You create an XY (Scatter) chart with only one row or column of values.

-and-
 * 1) You publish the chart as a Web page with interactivity.

-and-
 * 1) 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.

