I would like to generate some point chart from XML data.
The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel but it was unsuccessful.
You could open the XML file using Excel (there is an Import function hidden in the developer tab).
Afterwards you could generate a scatter plot like it's showed on one of the following websites:
Using your XML file, this would generate a scatter plot like this: