Types of Charts Line Charts

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Types of Charts: Line Charts


A line chart is used to analyze ups and downs of a tendency in a range of values. You can define it with one series of values where you will judge the evolution of an item over a period. When used with more than one series, this chart can be helpful in comparing values of the same category over the same period. The line chart can also be used to analyze values that do not share the same periodic variable. For example, you can use it to compare library attendance with regards to the real population number (which could be in hundreds of thousands or millions) with the number of people attending the library. In the latter situation, if the same axes are used to analyze, one category will almost disappear from the chart; the alternative is to separate the axes on the same chart.

Trend Lines

A trend line is a line added to a chart created as a column or else. It can be used to show the high points of the various values on a chart. A trend line is not a type of chart. It is only added to an existing chart to accentuate its tendencies.

To add a trend line to a chart, after creating a chart, right-click one of the column categories and click Add Trendline... This would add a line to the chart and open the Format Trendline dialog box.

After creating a trend line, you can change its characteristics. To do this, right-click the trend line and click Format Trendline... This would open the Format Trendline dialog box that you can use for various reasons, including specifying the color of the line.