Graphs in Excel and their use:
Apr 29 2014 04:30 PM
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.