Unsupported Chart Properties in Excel
The following IBM® Cognos® Business Intelligence
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 BI makes sure that Excel reuses the same color palette that is defined in IBM Cognos BI. However, Excel can only use the first 16 colors from the IBM Cognos BI palette. If the number of categories in a chart exceeds 16, the rest of the colors are taken from the default Excel palette.