Compile Textual Data and Visualize the Results Using Excel


This recipe takes data provided by textual analysis tools and uses Microsoft Excel to create graphs to aid in its interpretation.

    1. Take an electronic text from a source such as Project Gutenberg;
    2. Tidy up the text using a tool such as TAPoR Transform XML to HTML;
    3. Generate a list of words used in the text using the Voyant Corpus Term Frequencies;
    4. Generate a frequency distribution chart using Voyant Type Frequencies Chart for a particular word, phrase or partial word;
    5. Save the results to your computer as an XML file;
    6. Open the results in Microsoft Excel;
    7. Graph the results as a chart