COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: midhl on 03 Nov 2010 06:06:32 AM

Title: Legend values repeated when a chart report is exported to Excel
Post by: midhl on 03 Nov 2010 06:06:32 AM
Hi,

I've got an issue with the legends getting displayed for a bar chart when the output is exported to Excel.I have a barchart which has an X axis and 3 measures taken in series For Example,I have Cost,Sales,Revenue as 3 measures in the series of the chart.When the report is run,all the 3 measures are displayed as legends without any issues. However if this output is exported to Excel 2 of the measures, Sales and Revenue are displayed twice in the legend of the chart. Any reason for this peculiar behavior in Excel and any ideas how to resolve this.

Thanks in advance
Title: Re: Legend values repeated when a chart report is exported to Excel
Post by: midhl on 03 Nov 2010 07:06:48 AM
When the report is run in HTML legend is working fine as expected but when run in Excel some values are getting repeated