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:
- 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 kbprb kbpending KB230945