Create A Graph A Picture Is Worth A Thousand Numbers

Writen by Dee Reavis

You have data! The problem is to pull meaning out of it. The data has no value if you can't understand it.

The solution is to visualize that data. One of the simplest ways to do just that is with graphs. Graphs have a way of letting you see the big picture that is hidden within the mass of numbers.

Types Of Graphs

There are several types of graphs. Each has its strengths and weaknesses. The following list shows the more common graphs with their pros and cons:

Pros Cons

Line Graphs Great for seeing trends and seasonality in data. Not good with small amounts of data.

Pie Graphs Good for showing the percentage of the whole. One trick pony! No other uses.

Bar Graphs Better with small amounts of data. Not good with large amounts of data.

Uses For Graphs

Graphs have an amazingly wide number of uses. Some of these are listed below:

1. Show trend over time.
2. Illustrates data seasonality.
3. A visual indicator of volatility.
4. A predictor of future results.
5. What portion each part is of the whole.
6. A means of making comparisons between multiple sets of data.
7. Shows when a preset standard is being met.
8. Provides a starting point for regression analysis.
9. Initial analysis for curve fitting.
10. Helps visualize the relationship between two or more variables.
11. Simplifies reporting.
12. Identifies opportunities.

The Language Of Graphs

Graphs have a set of vocabulary that is necessary to know to fully understand their meaning. Most of the terms used come right out of your algebra textbook. If you know algebra, then you probably already know theses terms. If you don't know algebra then you need to learn these terms and their definitions.

X - It is common practice to call the horizontal values x.
Y - The vertical values are referred to as the y values.
X-axis - This is the horizontal line which separates the y positive values from the y negative values.
Y-axis - This is the vertical line which separates the x positive values from the x negative values. Slope - This is simply the slant of the graph. A positive value says the graph is rising. A negative value says the graph is falling.
Variables - These are the two part values consisting of a dependent variable and an independent variable. An example might be a graph of monthly expenses. The x variable is the month and the y variable is the expense. A data point might be February for $3000. When March comes along, the value might be $2500.

How To Create A Graph

It used to be necessary to have graph paper to create a graph. Now we have computers. Spreadsheets, specifically Excel, are often used to create computer graphs. Online resources are available to create your graph and even print it on your own printer. These resources are shown below.

Summary

When you create a graph you have made your data visual. When it is visual, it is much more comprehensible to the human mind. You have transformed your data into something that communicates meaning more clearly.

Dee Reavis has spent his career analyzing business situations to find the lowest cost methods of doing business. Graphing resources can be found at Create A Graph, Make A Line Graph and Make A Pie Graph.