Pie chart not showing in excel 2007 format.

[nsaxena]

Hi All ,

In my report ,i am using pie chart. This chart is appearing in HTML and PDF but in excel it is showing as blank.

Kindly help me in fixing this issue.

Thanks!

[MFGF]

Hi All ,

In my report ,i am using pie chart. This chart is appearing in HTML and PDF but in excel it is showing as blank.

Kindly help me in fixing this issue.

Thanks!

Works fine for me - using both a chart and a visualization. Other than that, there's not much more anyone can say based on the lack of detail you have posted. All we know is you have a pie - nothing else about the report or the package or your environment or what versions of Cognos/Excel or anything else, in fact.

MF.

[nsaxena]

Hi ,
Many thanks for replying.
I am using cognos 10.2.1 and excel version is 2013.

I am attaching the XML of report having pie chart(pie chart excel.txt).
When i am seeing output in excel 2002 format,it is appearing but formatting is getting totally break. All report page layout are over each other.

Attaching excel 2002 output in next post.

Kindly advice what is causing this,and any suggested change i can do. Thanks!

[nsaxena]

Attaching excel 2002 report output.

[MFGF]

Hi ,
Many thanks for replying.
I am using cognos 10.2.1 and excel version is 2013.

I am attaching the XML of report having pie chart(pie chart excel.txt).
When i am seeing output in excel 2002 format,it is appearing but formatting is getting totally break. All report page layout are over each other.

Attaching excel 2002 output in next post.

Kindly advice what is causing this,and any suggested change i can do. Thanks!

Looks to me like you have multiple levels of nested tables in the report. This isn't directly supported in Excel:

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.1.1.doc/c_table_col_widths.html%23table_col_widths?lang=en

You probably want to revisit the structures you are using to simplify them. Also, don't use percentages in your table width in the Size & Overflow property.

Cheers!

MF.

[nsaxena]

Hi ..thanks for sharing more insights.

I will check the link and re design report as per link. Will keep you posted. Thanks!

[nsaxena]

Hi MFGF,

I checked other reports which are using pie chart(output in excel),even tried putting only pie chart in report so remove layout formatting as you suggesting. Pie charts are still not showing up.

But data underneath pie chart is coming.Can be check by un hiding data sheet in excel.

Error we are getting is " Removed Part: /xl/drawing1.xml.part
(Drawing shape)"

I browse internet and find this link from IBM cognos : http://www-01.ibm.com/support/docview.wss?uid=swg1PM68171

We are using cognos 10.2.1 . (No fix pack). Does issue  seems to be related as mentioned in above IBM KB link.

Please advice.

Also in future we are going to use 10.2.2 .

[nsaxena]

just small update to above issue.

Pie charts are showing up in excel 2002 format.Its not coming in excel 2007 format.