Data Markers Missing From Lotus 1-2-3 Chart Opened in Excel

ID: Q88187

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

SUMMARY

A Lotus 1-2-3 chart opened in Microsoft Excel may be missing some of its data markers (for example, bars in a bar chart) if any of the chart series formulas include references to multiple columns.

Excel uses only the first column of a multi-column reference in a series formula. For example, if the original reference is A1:B5, Excel uses A1:A5.

WORKAROUND

After opening your chart in Excel, edit the series formulas to include multiple columns.

To edit the series formulas:

Bring your chart up in the active chart window.

Select the series you want to edit by clicking once on any of its data markers.

Note: All the data markers for a given series are the same color (or pattern).

In the formula bar, change the reference for the series values to include a reference to the additional column of values.

Enter the reference to the additional column immediately after the existing values reference, using the same form as the existing reference. Separate the two references with a comma and enclose them in parentheses.

For example, if the values reference in your series formula is

=SERIES(...,Sheet1!$A$1:$A$3,...)

adding a reference to values in the range B1:B3 results in

=SERIES(...,(Sheet1!$A$1:$A$3,Sheet1!$B$1:$B$3),...).

Repeat steps 2 & 3 for each series you want to reference values from multiple columns.

A detailed description of a series formula can be found on page 444 of the "Microsoft Excel User's Guide 1."

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 445-450

"Microsoft Excel Function Reference," version 4.0, page 387

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 26, 1999