OFF: Graph: Plotting Discontiguous Line and Scatter Graphs (101608)
The information in this article applies to:
- Microsoft Graph 97
- Microsoft Office 98 Macintosh Edition
- Microsoft Graph for Windows
- Microsoft Graph for Macintosh 3.0
- Microsoft Graph for Macintosh 5.0
- Microsoft Graph 98 Macintosh Edition
This article was previously published under Q101608 SYMPTOMS
When you create an xy (scatter) graph in Microsoft Graph, if your data is
incomplete, the data points on your graph do not connect continuously.
RESOLUTION
To connect the data points, enter the following into the data sheet
where data is missing:
This forces the scatter points to connect even when there is no data
available.
NOTE: In Microsoft Graph 5 and higher, you can leave the space blank (in
the
datasheet) and turn on empty cells plotted as interpolated using the
following
steps:
- On the Tools menu, click Preferences (Options in the Windows version).
- Click the Chart tab.
- In the Empty cells plotted as section, click the interpolated option.
Now the lines should connect.
| Modification Type: | Minor | Last Reviewed: | 8/16/2005 |
|---|
| Keywords: | kbprb KB101608 |
|---|
|