Hello,
I trying to make a PivotTable and Chart for my grades achieved at school. I have made a concept in Excel (see attached). The grade list is provided with both number (from 1 to 10) and letters (F= Fail, P= Pass, G= Good). How can this been displayed at my PivotTable? At the moment I got the #DIV/0! error message because Excel want to see a number format (I guess...).
For a better understanding:
"Math 11" = Exam number 1 at Year 1.
"Math 21" = Exam number 1 at Year 2.
etc.
Like to hear!
Bookmarks