Stacked Bar Chart - Merging Bars

Hi All,

Any help would be appreciated. Im trying to create what i thught was a very simple stacked bar chart in WebI. I have two categories with values, and effectively i want to show a bar version of a “Pie Chart”, whihc i can easily do in something like Excel.

However, when i create the Stacked chart in WebI, it alwas gives me two bars, rather than stacking them, do i need to click a button at the back end to achieve this?

Ive atached a pictutre to hopefully better explain what I mean.
Picture1.png


spencerh64 (BOB member since 2014-10-02)

Assign your category dimension to the Region Color instead of the Category Axis.

Depending on your version, you can assign Measure Names as the Category Axis. If you don’t have that option, create a dummy variable to use for the Category Axis. Use the formatting options to turn off the the display of the axis, if desired.


dtolley (BOB member since 2006-07-14)

@ dtolley, thanks so much, that works perfactly!


spencerh64 (BOB member since 2014-10-02)