Team-2 ( Types of Excel graphs)

There are many graphs or charts available in spreadsheet programs such as Excel and each has it own uses. They are as follows:

• Bar graphs
• Line graphs
• Scatter plot graphs
• pie charts

Bar graphs: Bar graphs also called column graphs are one of the most common types of graph used to display data. These are mostly used to show amounts or the number of times a value occurs. The amounts are displayed using a vertical bar or rectangle. The taller the bar, the greater number of times the value occurs.

http://spreadsheets.about.com/od/spreadsheetlessons/ss/excel_graph_use_2.htm

Line graphs: Line graphs are used to plot changes in data over time, such as monthly temperature changes or daily changes in stock market prices. They can also be used to plot data recorded from scientific experiments, such as how a chemical reacts to changing temperature or atmospheric pressure.

http://spreadsheets.about.com/od/spreadsheetlessons/ss/excel_graph_use_3.htm

Scatter plot graphs: Scatter plot graphs are used to show trends in data. They are especially useful when you have a large number of data points.

            When compared  line graphs connect the dots or points of data to show every change, whereas a scatter plot you draw a "best fit"line. The data points are scattered about the line. The closer the data points are to the line the stronger the correlation or affect one variable has on the other.

http://spreadsheets.about.com/od/spreadsheetlessons/ss/excel_graph_use_4.htm

Pie charts: Pie charts do not use horizontal and vertical axes to plot points like the others. They are used to chart only one variable at a time. As a result, it can only be used to show percentages.

The circle of pie charts represents 100%. The circle is subdivided into slices representing data values. The size of each slice shows what part of the 100% it represents.

http://spreadsheets.about.com/od/spreadsheetlessons/ss/excel_graph_use_5.htm

Bubble charts: Bubble charts are one way to show three dimensions of data in a flat 2D chart.  Bubble charts can facilitate the understanding of social, economical, medical, and other scientific relationships.

Bubble charts can be considered a variation of the scatter plot, in which the data points are replaced with bubbles.