Differences between 'Stacked Vertical' & '100% Stacked Vertical' Bar Charts

Charles M

Hi All,

I posted a few things a while back regarding some values (data markers) not fitting into some bar charts, specifically stacked vertical bar charts. BTW -Thanks for the replies

Now, I have found that there may be a decent workaround using the 100% stacked vertical bar chart. By using that style, and changing the data markers to 'actual values' (from default/percentages) it doesn't some to behave in the same way. Here is an example with the exact same data:

Stacked Vertical (some values missing ... in small "slices"):

100% Stacked Vertical (no issues with the bars ... looks like even some of the numbers are smaller, dynamically?)

However, as you may notice, the Y-axis still is expressed as a percentage ... and I cannot find a way to change it. Could be a little confusing as the the data and labels don't match/align.

Anyone have any ideas how to change the Y-axis labels to the actual values?

OBIEE 11.1.1.9.3 (OBIA 11.1.1.10.1)

Regards,

Charles

Gianni Ceresa

Hi,

You can't change the Y-axis labels to actual values, just because you would need an axis for each bar ....

Look at the first 2: the blue part of the first is 349K, but it is bigger than the blue of the second which is 400K. So there is no way that your Y-axis could be something else than a % as 349K can't be bigger than 400K in any other scale than %.

Gianni Ceresa

And, by the way, 3d bar charts? Really?

I imagine it isn't your personal choice but more a requirement, but still ... time to tell the manager asking it that we are in 2018 and a "flat" 2d bar is as good (and better) than a 3d bar chart

What about just not showing any value in the bars and add a small pivot right below the chart with the values? Visually you see the ratios between values and evolution over X axis, if you really want to focus on numbers you look right underneath it and you get all the details.

The idea being to provide the information knowing that OBIEE can't match 100% of the wishes of somebody asking a thing which was done by another tool or Excel. In this case focus on providing the information and ignore the visual requirement you have been asked for.

Charles M

Good point Gianni. I missed that perspective. I can see why those numbers can't be changed now. That definitely needs to be taken into consideration, if this style is to be used for this purpose.

Charles

Charles M

Hi Gianni,

Agreed. I only have so much influence over the "appearance" though .

We do have a table right above that graph with the numbers/data. In this way, the data is already presented. For what its worth, I did try using the "logarithmic scale". But, even still, the data markers are too crowded.

Sounds like we've exhausted all possible options here. Thanks for the feedback!

Charles