Graphs in Excel and their use:

1) Column charts -- Data that’s arranged in columns or rows on a worksheet can be plotted in a column chart. This chart is used when you want to compare data across both categories and data series.

2) Line charts -- These are often used to plot changes in data over time, such as monthly temperature changes or daily changes in stock market prices.

3) Pie and doughnut charts --
Data that's arranged in one column or row on a worksheet can be plotted in a pie chart. The data points in a pie chart are shown as a percentage of the whole pie.
Like a pie chart, a doughnut chart shows the relationship of parts to a whole, but it can contain more than one data series.

4) Bar charts --
Bar charts illustrate comparisons among individual items. In a bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.

5) Area charts --
These can be used to plot change over time and draw attention to the total value across a trend. By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole.

6) XY (scatter) and bubble charts --
Data that's arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart.
A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data.

7) Stock charts --
They can show fluctuations in stock prices. However, this chart can also show fluctuations in other data, like daily rainfall or annual temperatures. Make sure you organize your data in the right order to create a stock chart.
For example, to create a simple high-low-close stock chart, arrange your data with High, Low, and Close entered as column headings, in that order.

8) Surface charts --
This chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values. You can create a surface chart when both categories and data series are numeric values.

9) Radar charts --
Radar charts compare the aggregate values of several data series.

10)Combo charts --
Combo charts combine two or more chart types to make the data easy to understand, especially when the data is widely varied.

Column charts
A column chart shows data changes over a period of time or illustrates comparisons among items.

Bar charts
A bar chart illustrates comparisons among individual items.

Line charts
A line chart shows trends in data at equal intervals.

Pie charts
A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data.

XY (Scatter) charts
An xy (scatter) chart shows the relationships among the numeric values in several data series, or plots two groups of numbers as one series of xy coordinates.

Area charts
An area chart emphasizes the magnitude of change over time.

Doughnut charts
Like a pie chart, a doughnut chart shows the relationship of parts to a whole; however, it can contain more than one data series.

Radar charts
A radar chart compares the aggregate values of a number of data series.

Surface charts
A surface chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values.

Stock charts
This chart type is most often used for stock price data, but can also be used for scientific data (for example, to indicate temperature changes). You must organize your data in the correct order to create stock charts.

Cylinder, Cone, or Pyramid charts
These chart types use cylinder, cone, or pyramid data markers to lend a dramatic effect to column, bar, and 3-D column charts.