Basic Types of Graphs in MS Excel
We use graph to represent data. This is both an artistic and viewer-friendly representation of numbers. By using graphs, we can easily show the relationship of each data we have gathered. Here are some of the most commonly used graphs:
- Bar Graph or Column Chart
- Line Graph
- Scatter Plots
- Pie Chart or Circle Graph
- Box Plots
BAR GRAPH or COLUMN CHART - often used to display the amount or number of times a value occurs. It is useful when representing trends and when comparing data.
LINE GRAPH - is used to represent correlation. You can also use this type of graph to represent 80-20 rule or the Pareto principle.
SCATTER PLOTS - used to show trends in data. They are useful when there are large numbers of data points.
PIE CHART or CIRCLE GRAPH - can only represent only one variable at a time and does not use vertical or horizontal axis. The circle of pie chart represents 100%.
BOX PLOTS or BOX & WHISKERS DIAGRAM - useful in comparing distributions (bottom, median, and upper distribution).
More by this Author
Get rid of acute stiff neck by following 5 easy steps. These steps will help ease the pain and stiffness. If pain persists, immediate medical attention is recommended.
This hub outlines 10 of the most popular things that people are interested in collecting. Read through and you might find your collection in the list.
Visiting the Philippines, particularly Metro Manila? Try going to Las Pinas and find out what the greenest and cleanest city in Metro Manila could offer.
No comments yet.