Creating Network Graphs in Excel

NodeXL: A Microsoft Excel Template for Creating Network Graph Visualizations.

Network graphs have become a popular visualization in the past couple of years in not only the Mathematics and Computer Science, but in different fields such as the Humanities and Politics. It is one thing to read a piece of text and to be introduced to different characters and their relationship to each other in a novel, but it’s quite another thing to visually see the connects each character has with each other. These visual relationships can draw new conclusions or points of interest for research that were never discovered or approached before. This is in part why network graphs have gained popularity in the recent years. Continue reading “Creating Network Graphs in Excel”

See Text in Whole New Way: Text Visualization Tools

Data mining, concordances, word frequencies, all these things can be done to analyze text and to display the results (which are usually also in text form). Sometimes though, these results are hard to read, track, and to see correlation and relationships between bodies of texts and words. Text visualization adds another dimension to data mining a text. You can see in a simple and fast way how many words make up a text, what words have frequencies next to other words, and analyze the overall theme of a text and its corpus. The following tools listed below will help you get started with building a word frequency list and using your text to visualize your data, for the most part, in an easy and simple manner. Continue reading “See Text in Whole New Way: Text Visualization Tools”

Google’s Image Chart Editor

google_image_chart_editor.pngToday I came across a cool and easy way to create charts inside my browser. The tool I found was Google’s Image Chart Editor. What’s nice about this tool is that I can choose different chart styles (maps, pie charts, graph charts, just to name a few), enter in the data and edit the graphics and appearance of the chart. You also have the ability to email the link, embed the chart into a website, or embed with Visualization API. It also edits the chart fast when you change the data.

To try out the Image Chart Editor, click on the link below:

Ngram Viewer

Google Lab’s new tool, the Books Ngram Viewer allows you to search the corpus of Google Books for up to 5 keywords over a certain period of time. The Ngram Viewer displays a graph chart to show you how often that work was published in the Google Books corpus over that period of time. If you would like to try out this visualization tool (which is free), click on the link below: