If you are unable to create a new account, please email support@bspsoftware.com

 

Report Visualization - Chart Truncates Legend Label in Excel Expor. How to Stop?

Started by Eric.Seitz, 07 Jun 2022 10:37:41 AM

Previous topic - Next topic

Eric.Seitz

Howdy folks!

I'm using Cognos Analytics 11.1 R7

Maybe I've been missing something obvious but I've been having a weird annoying problem with some charts I'm working on.

For some reason the legend keeps being truncated when exporting to excel despite looking perfect in Cognos and having plenty of room.
For example the legend looks sorta like this
Cognos:
Column                         Line
* # New Accounts       * Total New Balances

Excel:
Column                       Line
* # Ne...                 * Total New Balances

I've tried renaming the item a few different ways and various text sizes but nothing seems to work. The first 'Column' label always ends up truncated no matter it's length.
I've dug around the chart properties but I don't see anything else useful. Searching the web I see older posts about "truncation" but there's nothing in my Cognos version. All the posts are 5-10 years old.

Any thoughts?
Thanks!