Friday, November 5, 2021

Charting compatibility issues

The Compatibility Checker found one or more charting-related compatibility issues.

Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

Issues that cause a significant loss of functionality

Issue

Solution

A chart contains a title or data label with more than 255 characters. Characters beyond the 255-character limit will not be saved.

What it means    Chart or axis titles and data labels are limited to 255 characters in Excel 97-2003, and any characters beyond this limit will be lost.

What to do    In the Compatibility Checker, click Find to locate the titles or data labels that exceed the 255-character limit, select the titles or data labels, and then edit them so that they contain 255 or fewer characters.

Some formatting on charts in this workbook is not supported in earlier versions of Excel and will not be displayed.

What it means    Custom shape fills, shape outlines, and shape effects (such as glow and bevel effects, or gradient line formatting) are not available in Excel 97-2003 and cannot be displayed.

What to do    In the Compatibility Checker, click Find to locate the custom formatting that is not supported, and then change that custom formatting to formatting that is supported in the earlier versions of Excel.

Earlier versions of Excel only support the colors from the color palette. When the workbook is opened in an earlier version of Excel, all line colors will be mapped to the closest color in the color palette, and a chart may display multiple series in the same color.

What it means    Excel 2007 and later supports up to 16 million colors, but Excel 97-2003 limits the colors to those that are available on the standard color palette. Colors that are not supported will be changed to the closest color on the standard color palette, which may be a color that is already used.

What to do    In the Compatibility Checker, click Find to locate the custom colors that are not supported, and then change the unsupported color formatting by using the standard color palette.

This workbook contains charts with more data points than can be displayed by earlier versions of Excel. Only the first 32,000 data points per series in 2-D charts, and the first 4,000 data points per series in 3-D charts, will be displayed when the workbook is opened in a version of Excel prior to the current version.

What it means    In Excel 2010 and later, you can use more than 32,000 data points per series in 2-D charts and more than 4,000 data points per series in 3-D charts. This exceeds the limits of data points per series in Excel 97-2007.

What to do    In the Compatibility Checker, click Find to locate the chart that exceeds the limit of data points per series, and then make the necessary changes to keep data points within the limit.

Top of Page

No comments:

Post a Comment