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


The information in this article applies to:

  • Microsoft Excel 2000
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-
  2. You publish the chart as a Web page with interactivity.

    -and-
  3. 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.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbchart kbpending kbprb KB230945
©2003 Microsoft Corporation. All rights reserved.