COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Connection, Viewer, Scheduler => Topic started by: sakthivelmani on 12 Oct 2014 11:15:04 AM

Title: Show the bar chart values clearly without overlapping with the bars
Post by: sakthivelmani on 12 Oct 2014 11:15:04 AM
Hi All,

I am creating a bar chart and the values in the bar chart gets merged into the bar and the values are not clearly visible. is there any way i can move the value a little away. I have attached the sample

Thanks,
Sakthi
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: bdbits on 13 Oct 2014 09:38:31 AM
After playing around with various options, the problem appears to be that Cognos is not accounting for the top of the 3D bar. If you flatten them by setting Depth to 0 (under General properties), the values do not collide. But, that changes the appearance.

If you want to keep the 3D look, the only viable alternative I could see was moving the labels to the inside of the bars (right-click chart, Show Values, change Value Location).
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: sakthivelmani on 13 Oct 2014 09:46:03 AM
Thank you, bdbits. I really need to keep the depth because when i have drill through set up in the chart and when i have small values, i couldnot click on them to see the drill through. If you have any solution for that, it will be really helpful for me.

And in case of moving the value to inside of the bar, how can i do it in the current chart in Cognos 10.2. I know how to do it in Legacy chart. Please let me know


Thanks again for your response

Sakthi
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: bdbits on 13 Oct 2014 10:54:42 AM
Did this not work? I did this on a brand new chart, 10.2.1, using the current (not legacy) charting engine.

Quote from: bdbits on 13 Oct 2014 09:38:31 AM
...moving the labels to the inside of the bars (right-click chart, Show Values, change Value Location)...

For size, if you have not already you can resize the entire chart larger, which will scale up the contents.
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: sakthivelmani on 13 Oct 2014 11:04:11 AM
No bdbits, when i right click and do show values, i get the window like the one attached

And for the size, i cannot increase the size because the user can select different filter , when they select the filter that brings less vale, the chart looks unusually larger with thicker bars.
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: bdbits on 13 Oct 2014 11:33:10 AM
That's odd... I could not find a bar chart type that did not show this for Show Values.

The only solution that comes to mind for chart sizeing would be using drill-throughs with different targets, instead of drill up/down. Maybe someone else will have some better ideas.
Title: Re: Show the bar chart values clearly without overlapping with the bars
Post by: sakthivelmani on 13 Oct 2014 12:30:20 PM
Yeah..its wierd. Thanks a lot for helping me

Sakthi