A chart is a graphical representation of spreadsheet data. Chart gives us clear idea about data and helps us make comparisons and analyze data.
Charts can be stored separately on chart sheets which can be printed, viewed or edited or they can be embedded in the current sheet so that they become a part of it.
Different types of Chart:
1. Area Chart –
Area chart shows the magnitude of change over time. It is used when several components are changing and the user is interested in the sum of components. The area chart is a stacked line char, with the area between lines filled with color or shading.
2. Bar Chart –
A Bar Chart consists of a series of horizontal bars that allow the comparison of the relative size of two or more items at one point of time.
The Bar Chart has 3 primary types –
a) Stacked bar chart
b) 100% stacked bar chart
c) 3-D bar chart
3. Column Chart –
A Column Chart consists of a series of vertical columns that allow comparison of the relative size of two or more items. Each column in a column chart is a single data point or number on the sheet.
There are two types of Column Charts -
a) 100% Stacked column chart
b) 3-D column chart
4. Line Chart –
A Line Chart is used to show trends over time. In a line chart, each of the data series is used to produce a line on the chart. With each number in the range producing a data point on the line.
There are 2 significant variations in the Line Chart –
a) 3-D line Chart
b) High – Low – Close charts
5. Pie Chart –
A Pie Chart is used for comparing the percentages of a sum that several numbers represent. The full pie is the sum, and each number is represented by a slice. A pie chart can be exploded. There is only one data series in a pie chart.
6. Doughnut Chart –
A Doughnut Chart is similar to the pie chart. However, the Pie Chart is restricted to one data series while the Doughnut chart is not.
7. Radar Chart –
Radar Charts show data changes in relation to each other. The values axis radiates from the center point. Data from the same series is connected by lines. Radar Charts can be used to plot several interrelated series and easily make visual comparison.
8. Scatter Chart –
It shows the relationship between the pairs of numbers and treads they present. For each pair, one of the numbers is plotted on the X – axis and the other is plotted on the Y – axis. Where they two meet, a symbol is placed on the chart. When a number is plotted, a pattern may emerge.
 Attachments
CHARTS IN MS EXCEL (34276-2189-CHARTS-IN-MICROSOFT-EXCEL.doc)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|