Charts in Ms Excel

Topics: Chart, Bar chart, Pie chart Pages: 6 (2052 words) Published: June 18, 2013
Microsoft Excel supports many kinds of charts to help you display data in ways that are meaningful to your audience. When you use the Chart Wizard to create a chart — or when you use the Chart Type command to change an existing chart — you can easily select the type you want from a list of standard or custom chart types. For an overview of some standard chart types and their subtypes, click any or all of the following: Column charts

A column chart shows data changes over a period of time or illustrates comparisons among items. Column charts have the following chart sub-types: Clustered Column     This type of chart compares values across categories. It is also available with a 3-D visual effect. As shown in the following chart, categories are organized horizontally, and values vertically, to emphasize variation over time.

Stacked Column     This type of chart shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. It is also available with a 3-D visual effect. 100% Stacked Column     This type of chart compares the percentage each value contributes to a total across categories. It is also available with a 3-D visual effect. 3-D Column     This type of chart compares data pointsHYPERLINK "javascript:AppendPopup(this,'865612420_1')" (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) along two axes. For example, in the following 3-D chart, you can compare four quarters of sales performance in Europe with the performance of two other divisions.

Bar charts
A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-types: Clustered Bar     This type of chart compares values across categories. It is also available with a 3-D visual effect. In the following chart, categories are organized vertically, and values horizontally, to place focus on comparing the values.

Stacked Bar      This type of chart show the relationship of individual items to the whole. It is also available with a 3-D visual effect.

100 % Stacked Bar     This type of chart compares the percentage each value contributes to a total across categories. It is also available with a 3-D visual effect. Line charts
A line chart shows trends in data at equal intervals. Line charts have the following chart sub-types: Line     This type of chart displays trends over time or categories. It is also available with markers displayed at each data value.

Stacked Line     This type of chart displays the trend of the contribution of each value over time or categories. It is also available with markers displayed at each data value. 100% Stacked Line     This type of chart displays the trend of the percentage each value contributes over time or categories. It is also available with markers displayed at each data value. 3-D Line     This is a line chart with a 3-D visual effect. More information

For detailed instructions on how to use Line charts, see Creating XY (Scatter) and Line charts. Pie charts
A pie chart shows the size of items that make up a data seriesHYPERLINK "javascript:AppendPopup(this,'111824051_2')" (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one 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. Pie charts have the following chart sub-types: Pie     This type of chart displays the contribution of each value to a total. It is also available with a 3-D visual effect, as shown in the following chart.

Exploded Pie    ...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • to create chart in MS Excel Essay
  • Gantt Chart Using Excel Essay
  • Project Ms Excel Essay
  • Ms Excel Essay
  • Ms Excel Essay
  • Essay about ms excel
  • Excel 2010 Pivot Chart Creation Essay
  • Week 4 Ms Excel Exercise Essay

Become a StudyMode Member

Sign Up - It's Free