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 to prevent permanent loss of data or incorect funtionality.

Compatibility 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.

In Microsoft Office Excel 2007, you can use more than 255 characters in chart or axis titles or data labels. Titles and data labels in earlier versions of Microsoft Office Excel are limited to 255 characters, and any characters beyond this limit will be lost.

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.

For more information, see:

Edit titles or data labels in a chart

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

In Excel 2007, you can change the look of chart elements (such as the chart area, the plot area, data markers, titles in charts, gridlines, axes, tick marks, trendlines, error bars, or the walls and floor in 3-D charts) by applying custom shape fills, shape outlines, and shape effects. Some custom formatting (such as glow and bevel effects, or gradient line formatting) is not supported in earlier versions of Excel and will be lost.

In the Compatibility Checker, click Find to locate the custom formatting that is not supported, and then change or remove that custom formatting.

For more information, see:

Change the shape fill, outline, or effects of chart elements

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.

Excel 2007 supports up to 16 million colors, but earlier versions of Excel are limited to the colors 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.

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.

For more information, see:

Change the shape fill, outline, or effects of chart elements

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×