Pie chart how to hide extra comma

[krishdw85]

Hi All,

In the attached chart i just want to see CMB-LLC 33%, not sure why it is displaying extra 33 and comma in between. For pie chart i used only one measure & one dimension. I am running in excel version and i am using 10.1 . How to hide those commas extra 33.
Appreciate if you could help me here. Thanks in adv.

[bdbits]

If you run to HTML do you see the same? Then it is probably in your data that way.

If it only shows exported to Excel, you would need to look at where Excel is getting the labels.

[krishdw85]

i dont see comma and extra numbering in html & pdf...it is cmg only in excel output....i dont think cognos has control over excel version...

[krishdw85]

Guys any update... getting issue in excel report , but not in pdf

[BigChris]

It's excel rather than Report Studio that's giving you the problem

[krishdw85]

Its Excel giving the issue, in PDF report i dont see those extra comma's.

[krishdw85]

Cognos dnt have control on Excel default formats. We have to manaully edit the excel sheet.
PFA. If any inputs appreciate.