In Numbers, how can I convert the values of a table into percentage values rather than absolute values ?
The percentage are computed per column. The sum of the cells in a column is 100%.
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
If I'm not mistaken you could do that more or less easily:
Say for example column comedy.
The total is 534 (sum).
The sum of 24.71+0.56+0.18+74.53 == 100% (minus rounding, add more decimals for more precision).
So if you add a final ROW with the SUM (below technology for example) you can cause each cell to perform a Cell * 100 / TOTAL_OF_COLUMN and get your %.
What am I missing?