I've been using an own class with some commands for writing exams in my classes (I'm a teacher). In this, I use a rather complex point system (why I do this is kind of irrelevant) with 9 different kind of points. In order to show the students what kind of points they earned on a particular question, I've been using
newfile to create a
.xml file showing the question number and what kind of point that can be earned on that particular question, as shown in the picture (when opened in Excel)
When I enter the questions I put some point commands to that question (9 different) which each add a row to the
.xml file. The class uses a load of counters and commands, and lots of text to produce the beginning and ending of the
I've come to the conclusion that I really need a barchart, showing the points earned and not earned, but
.xml in Excel wont give me any (well, it does but it can not be saved so I can't harvest the code by opening the file in a text editor).
So, this might be more Excel related than LaTeX, but since I use LaTeX to produce the file in question, I thought I could ask it here: Is there a way (or package) to create Excel files via LaTeX, that can add charts (in some way)? Or is there a better way than using
.xml? Perhaps a different file format is needed?