Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
That url gives We can't show you that page –  Mark Feb 24 '11 at 16:09
    
thanks I corrected link –  marcinn Feb 24 '11 at 17:11
    
I see some macro here answers.google.com/answers/threadview/id/343380.html –  marcinn Feb 24 '11 at 20:59

1 Answer 1

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:

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.