Unsupported Chart Properties in Excel
The following IBM®
Cognos® Analytics
chart properties are not supported in the Microsoft Excel spreadsheet software:
- tool tips
- conditional text
- depth
- visual angle
- show values
- marker text location
- show baseline
- new note
- new marker
- truncation text and allow n-degrees rotation category labels
- border
- margin
- box type
- font and font alignment
- footer
- subtitle
- regression line
- baseline
- Include Zero For Auto Scale
- Summarize Small Slices
- Summarize Small Items
In addition, IBM Cognos Analytics makes sure that Excel reuses the same color palette that is defined in IBM Cognos Analytics. However, Excel can only use the first 16 colors from the IBM Cognos Analytics palette. If the number of categories in a chart exceeds 16, the rest of the colors are taken from the default Excel palette.