pivot table question

[lezawang]

Hi
In this excel sheet, there is a column called "Satisfaction on management" (in Data2 sheet) and it has values from 1-5. So the author created a pivot table and has a Row label in pivot table like this

[TABLE="width: 500"]
<tbody>[TR]
[TD]Satisfaction on mangment[/TD]
[/TR]
[TR]
[TD]very satisfied[/TD]
[/TR]
[TR]
[TD]unsatisfied[/TD]
[/TR]
[TR]
[TD]mixed[/TD]
[/TR]
[TR]
[TD]very unsatified[/TD]
[/TR]
</tbody>[/TABLE]

My question, how the author transferred 1-5 into words like satisfied, not satisfied etc. Is there any feature in pivot table to do that or he did it manually? the files can be found below. thank you.

http://myy.haaga-helia.fi/~taaak/r/mypivot.xlsx

 

[Marcelo Branco]

Maybe with Conditional Formatting using custom formats

Rule 1 (cell = 1)
Format > Custom
[=1]"Very satisfied"

Rule 2 (cell = 2)
Format > Custom
[=2]"satisfied"

and so on

See
https://www.youtube.com/watch?v=wslp2BqHuz8

M.