Unsupported Chart Properties in Excel

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