Data Series Are Truncated

The Microsoft Excel spreadsheet software may group data series or categories differently when compared to a chart produced by IBM® Cognos® Business Intelligence.

A 1 KB buffer limit in Excel limits the maximum number of data series per chart to 120. Data series over 120 are truncated.

Parent topic: Limitations When Producing Reports in Microsoft Excel Format