Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have bar chart
here i am mentioning single bar it self used space and non used space like
for example i have 100 md hard disk.
used space is 67.5 mb mb and un used space is 33.5 mb in bar chart i am showing it in single bar it self used space in one colour and not used space in another colour
my intention i want show it in percentage manner like
B
A
R
C ------ used space 67.5% ( now i have like this 67.5)
H
A
R --- un used space 33.5 (now i have like this ( 33.5)
T
Hi,
Use a staked chart
Create a expression:
=Used space/Total Space
=freespace/total space
in Numbers tab select the expression and select %.
Regards
KC
i dont have field called total.
they have used option in presentation tab > sub total on below and calculating
You cant get anything in % unless you dont know the total.
Can you share your sheet it will be helpful to understand.
Regards
KC
sum(usedspace)/sum(totalspace) and
sum(freespace)/sum(totalspace)
is this expressions are right? can i use in stacked bar chart?
Right looks good to me.
Then go to Number tab in you chart, select the expression
click on override document settion and tick show in percentage.
Hope it works.
Regards
KC