The stacked area graph on the right is used for drawing attention to the difference in magnitude of two categories and displays the values as percentages. In this example, we represent the relationship between the number of datasets worked on by an analyst and the number of hours they worked. This is used for the same purpose as the line graph, which visualises trends and compares data. The area graph is available within the line graph menu. Stacked lines like stacked columns are used to represent percentages instead of the actual values. We have different line graphs or line graphs available for use in excel, such as stacked lines and 100% stacked lines. We can see that Rohit is the only one whose pay raise has increased while other’s pay raise percentages have remained constant over the last year. For example, if we wanted to see how the current rise compares to the last raise for different people in the earlier examples, we would get something like this: This is an excellent graph in Excel to use for representing trends and comparing performance. This type of graph is used when we need to visualize data like an increasing or decreasing series over a period. The next type of graph we are going to discuss is called a line graph. There are 3D version as well as horizontal versions of these graphs in excel. The difference between these is that while a stacked column represents actual values, a 100% stacked column represents the values as percentages. For example, we have been working with only two columns in the last two examples, now if we want to include the hours worked as a third column and compare the hours worked with the number of datasets visually, we can either use a stacked column or a 100% stacked column which would look like this: These types of graphs can be used for expanded datasets. There are different types of bar graphs available in Excel, such as stacked columns, 100% stacked column, 3D columns etc. The same data that we used in the pie graph example would look like this: We use these different types of graphs where we need to see and compare values across a range.

The next one in the list is a column graph, also called a bar graph in statistics.

Excel 2016 charts and graphs