Chart is a graphic representation of data from a worksheet.
Types of Charts Column Chart – Displays data changes over a period of time or illustrates comparisons among items. Bar Chart – This chart illustrates comparisons among individual items. Subtypes: Clustered Bar – Compares values across categories Stacked Bar – compares each value to its total across categories.
Column Chart
Bar Charts
Types of Charts Line Chart – Shows trends in data at equal intervals. Subtypes: Line – displays trends over time or categories. Stacked Line – displays the trend of the contribution of each value over time or categories. 3-D Line – this line chart has thee-dimensional visual effect.
Line Chart
Types of Charts Pie Chart – shows the size of the items that make up a data series, proportional to the sum of the items. Subtype: Pie – This type of pie chart displays the contribution of each value to a total. Exploded Pie – This type of pie chart displays the contribution of each value to a total while emphasizing individual values.
Types of Charts Pie of Pie – This pie chart consolidates some of the given data as one part of the pie, then sets these data individually into a second pie. Bar of Pie – This pie chart does the same thing as the Pie of Pie type, only, the consolidated data is identified with a stacked bar chart.
Pie Chart
Types of Charts XY Chart – (also called 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 Chart – This chart emphasizes the magnitude of change over time. Doughnut Charts – Shows the relationship of parts to a whole; however, it can contain more than one data series.
XY Chart
Area Chart
Doughnut Charts
Types of Charts Surface Chart – This chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicates areas that are in the same range of values. Bubble Chart – It compares sets of three values and can be displayed with a three-dimensional visual effect. The size of the bubble, or data marker, indicates the value of a third variable.
Bubble Chart
Types of Charts Stock Chart – This type of chart is most often used for scientific data. Cylinder, Cone, or Pyramid Charts – These chart types use cylinder, cone, or pyramid data markers, respectively, to lend a dramatic effect to column, bar, and three-dimensional column charts.