What are the various types of charts? Explain each.

The various types of charts in Excel are given below:

Line Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data over time, set against a common scale and are therefore ideal for showing trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis and all value data is distributed evenly along the vertical axis. 

Pie Chart: Data that is arranged in one column or row only on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are displayed as a percentage of the whole pie. 

Scatter Chart: Data that is arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart. Scatter charts show the relationships among the numeric values in several data series or plots two groups of numbers as one series of XY coordinates. 

Bar Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items. 

Area Chart: Data that is arranged in columns or rows on a worksheet can be plotted in an area chart. Area charts emphasize the magnitude of change over time and can be used to draw attention to the total value across a trend, e.g. data that represents profit over time can be plotted in an area chart to emphasize the total profit.