Can you make bars on a stack chart start from zero? Currently, I am dealing with showing percentages with values of 70% and 80% as a result I get an X-axis of 150%. I want to make the stacked bars start from zero for each dimension rather than adding on top. I have tried subtracting the smaller percent from the bigger one, this shows the right view (bar up to 80%) but the incorrect value on the second bar (10%). Also I have tried a 3D combo stacked/clustered chart, this works but when showing the value its small, unreadable, and difficult to decipher which bar it belongs to. Is there a way to make the stacked bars start from zero for each dimension?
Using Cognos 10.1.1 FP2.
Click on the X axis.
Not the x axis labelbit the actual X axis.
The black line on the very edge of the chart.
It'll be tagged "Primary Axis"
The look at the "Axis Range" options.
That should give you all you need.
This option works on the 3D combo chart but not on the stacked chart. I have been able to get the view I want by changing the Grouping Type but have run into a new issue with showing the values. The positioning of the values is still messed up by cognos positioning values as if the bars were added (Centered is off). I tried the Inside Bottom position to get it as clear as possible but run into view issues when there is a 0% overlapping occurs. Is there a way to put an IF statement when showing values to just hide values below 1? Attached is an example of overlapping.