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

 

Show the bar chart values clearly without overlapping with the bars

Started by sakthivelmani, 12 Oct 2014 11:15:04 AM

Previous topic - Next topic

sakthivelmani

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

bdbits

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).

sakthivelmani

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

bdbits

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.

sakthivelmani

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.

bdbits

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.

sakthivelmani