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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Make Stacked Bar Chart start at zero

Started by cognoso, 03 Feb 2015 03:26:14 PM

Previous topic - Next topic

cognoso

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.

Robl

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.

cognoso

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.