Percentage in Bar Chart

building reports webintelligence
1

Hi! Does anyone know how we can make a bar chart show the percentage value instead of the numeric value?

switchblade79 :us: (BOB member since 2017-03-24)

2

I was struggling with this last week as I thought it was a property of the chart but couldn’t get anything to work
In the end I resorted to the following:
[list]turn the chart into a Table (right-click chart, Turn Into, Vertical Table)
apply percentage number format to column (right click column, Format Number, select appropriate % format)
turn the table back into a bar chart
[/list]

buzz :australia: (BOB member since 2005-08-12)

3

Thanks! Does that mean you had to create a variable that calculated the percentage first?

switchblade79 :us: (BOB member since 2017-03-24)

4

Nopes, it’s an option by default, to show Percentage or Value in Chart.

M H Mohammed :us: (BOB member since 2010-06-16)

5

Yes, if you are using a column chart and want to display the value as a percentage of the whole, you need to create a variable that calculates the percentage and use that in your graph. If you simply have it display your measure as a percentage, your values will be 100% because it’s calculating as a percentage of each bar, not the total.

dtolley (BOB member since 2006-07-14)