How can i associate 2 sheets that have the same numbers in them but one has text also. For exemple one sheet is just showing one number (1) and the other sheet is showing a number (1) but also some text in the cell (absense). When I try to make a pie chart showing some fact about, it is only the number that is showing but I want the text to show instead.