Unit 4-Lesson 1 Introduction to Charts: Choosing the Right Graph

Khadijah and sorayia choosing the right graph

View more presentations from gibbykhhs.

There are four different graphs we can create in Excel. One is a bar graph, it is the most common type of graph, and another name for it is column charts. The purpose of the bar graph is to show the amounts or the number of times a value occurs. Second is the line graph. Line graphs are used to plot changes in data over time, an example would be monthly temperature changes. The data points in line graphs represent the changes in your data. The third graph is a scatter plot, which shows the trends in data; when you have large numbers of data points it is most useful. In scatter plots, if the best fit line increases, it is a positive correlation, if the best fit line decreases, then it is a negative correlation in the graph. Pie charts are used to show a percentage of particular items that represents a data series, and another name for pie charts is circle graphs. The last graph is a pie chart; every data values would add up to 100%. Unlike other graphs and charts, pie charts don’t use horizontal or vertical axes to plot points.