What's the easiest way to scrape a Wikipedia table into a graph?
What's the easiest way to quickly take a column like these marathon开发者_如何转开发 times and display them as a graph? Just an ad-hoc momentary view is sufficient; fancy formatting, editing, or saving as a file type isn't a concern.
Selecting, copying, and pasting into Open office's calc worked for me. Formatting is a bit weird, but that's easily fixable.
- drag-select the table contents
- copy
- open Excel 97
- click Edit, Paste special..., Text
- select first through last cells in column A
- click Chart Wizard icon
- click Finish (for default chart; axis labels need work)
精彩评论