Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a Bar chart, which I would like to show both the actual value as a number and a percentage on the bar.
I have tried playing around with the data-points, and all the options on the 'Expressions' tab, but have only managed to come up with the following(see image)
Ideally, there must be a way in which you can have 2 measures/values on a bar?
Any ideas?
Thanks![:)]
Hi, Check the QVW that i attached. One mot=re thing, in "Sheet Properties",pesentation tab,"Value on Data Points" category , u need to check the "Vertical" , to get values as u wish.
Hello,
Do you mean "two measures in the same bar" (in your case above, only one bar, red and blue)? If so, go to the chart properties, Style, and select "Stacked" instead of "Grouped". That should do.
Hope that helps.
Well, no. I mean, 2 values/data points on 1 bar, but the same measure/expression.
So, in my case, I'd like to see both the % values and the number on 1 bar(data-point).
Not sure if this is possible.?
Hi, Check the QVW that i attached. One mot=re thing, in "Sheet Properties",pesentation tab,"Value on Data Points" category , u need to check the "Vertical" , to get values as u wish.