ADVANCED FEATURES OF EXCEL
A chart is a
graphical representation of data in a worksheet .it is an effective way to display
data in a pictorial form. It helps to provide a better understanding of large
quantities of data. Charts make it easier to draw comparisons and see growth
and relationship among the values and trends in data. They provide an accurate
analysis of information.
v COMPONENTS OF A CHART
Let us learn about various components
of a that are depicted.
1. CHARTAREA: Chart are includes all the area and object in the chart.
2. CATEGORY AXIS: Category axis or X-axis is the horizontal axis of a chart.
3. VALUE AXIS: Value axis or Y-axis is the vertical axis used to plot the
values .It is located on the left side.
4. DATA SERIES: Data series are the bars, slices, or other element that
show the data values. If there are multiple data series in a chart, each will
have a different colours or style.
5. CATEGORY NAME: Category names are the labels, which are displayed on the X
and Y-axis.
6. PLOT AREA: Plot area is a window within the Chart area. It contain the
actual chart itself, and includes plotted data series, category, and value
axis.
7. LEGEND: It depict the colors, pattern, or symbol assigned to the
data series. It helps to differentiate the data.
8. CHART TITLE: It describes the aim and contents of the chart.
9. GRIDLINES: These can either be horizontal or vertical lines depending
on the selected chart type. They extend across the plot area of the chart.
Gridlines make it easier to read and understand the value.
TYPES
OF CHART
MS Excel offers a wide range of charts
to interpret data .These charts share some common features, which assist the users in
comprehending the data logically.
We are using the sample data as to
create the chart.
BAR CHART
It illustrates the comparison between
the individual data items. It displays data in the form of long rectangular
rods called bars, that are placed vertically and horizontally on the chart
area. In this type of chart, categories are represented on the vertical axis
and values are represented on the horizontal axis.
You can also display the bar chart in
stacked from understand the relationship between entities. They can be
displayed as 2D or 3D graphs.
COLUMN
CHART
This chart is used for
displaying data that show different trends over a period of time. It is the
default chart type of MS Excel. In this type of chart, the categories are
organized horizontally, and the values vertically to emphasize the magnitude of
change over a period of time.
LINE CHART
It is in form of lines and used to
illustrate trends in data at equal intervals. It is quite similar to potting a
graph on a graph paper with its values on the X and Y axis. It is useful in
emphasizing continuity by showing the
change in data over a period of time. It is generally used to represent a huge
amount of data.
AREA
CHART
It is unique version of lines or column
chart. This type of chart has greater visual impact than a Line Chart. It
emphasizes the magnitude, the volume of change over time. By showing the sum of
the plotted values, an Area chart also display the relationship of part to a
whole.
XY (SCATTER) CHART
This chart
has two value axis. One set of numerical data is displayed along the horizontal
axis, X-axis, and another set is represented by the vertical Y-axis. X-axis is
usually assigned to an independent variable, and the Y variable then becomes
the dependent variable. Each value of Y variable depend upon the corresponding
value of variable X. the chart combines these values into single point at the
intersection of X and Y numerical values.
PIE
CHART
This chart display data in the form of a circle that is
divide into a series of segments. These segments show the relative size of each
item in the chart. It always shows only one data series and is useful when you
want to emphasize a signification element. This chart type work best with
smaller number of values.
0 Comments