Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a feeling this should be simple but just can't find the answer. I have a simple block chart counting the number of students on each course. I have the expression set to Relative and have ticked the 'Show Numbers with labels'
What I would like to do is show, in the block, the percentage and the number that represents e.g. History (12.5%, 45) I can only get one of these to show at a time. I tried the same method you'd use with a pie chart, using a second identical expression but the only 'Display Options' that can be changed is 'Text as Pop-up'
Can anyone tell me if it is possible to show the value and the percentage this represents in a block?
thanks
John
The trick way is create a dual expression
For example
=dual(
'Value:' & sum(Value) & chr(10) & '% = ' & sum(Value)/sum(total Value),
sum(Value)
)
It´s important to *not* format at "Numbers" tab, mark it "General"
The trick way is create a dual expression
For example
=dual(
'Value:' & sum(Value) & chr(10) & '% = ' & sum(Value)/sum(total Value),
sum(Value)
)
It´s important to *not* format at "Numbers" tab, mark it "General"
you can just mark 'Show Numbers with Labels' in:
Chart Properties -> Presentation
totally solved it for me (: