MAKE CHART IN MS EXCEL

CHARTS IN MS EXCEL

Microsoft provides another powerful and easy to use tool, which allows you to present the data entered into the worksheet in a pictorial form called CHARTS. Charts are more attractive and appealing than the simple presentation of data. It is the same saying ‘A picture is worth a thousand words’.

CHARTS IN EXCEL

CHART is an effective way to display data in pictorial form. Charts make it easier to draw comparison and see growth, draw relationship among the values and trends in data. Charts provide more accurate analysis of information. On inserting charts, the data is displayed in a special window called Datasheet.

A chart could be used for:

The monthly budget of a family.
The monthly sales of a company.
The comparative performance of the students of a class.
The rainfall trends in the last four years.
The yearly expense of a family.
The comparative revenues of financial years.
COMPONENTS OF A CHART

CHART TITLE
Chart title is the title or name of the charts that appears at the top of the chart which tell the user what the chart is all about.

CHART AREA
The chart area includes all the area and objects in the charts.

X-axis
It is also known as Category Axis. It is the horizontal axis of the chart on which each category is represented with a mark on it.

Y-axis
It is also known as value Axis. It is the vertical axis of the chart along which the value of each data point is plotted.

Data Series
The set of many data entries which come from the same row or column in a worksheet are called Data series.

Plot Area

It is rectangular area bounded by the two axes. The x-axis and y-axis define the two sides of the rectangular plot area. The base area (the XY plane) in a 3-D chart is known as the Floor and the vertical areas (the YZ and XZ planes) are known as the walls.

Therefore, in a 3-D chart, the two walls and floor make up the plot area.

Gridlines:
The parallel lines along the X-axis and Y-axis in the plot area which makes it easier to identity the value of each data point on the chart are called Gridlines.

Legends:
Legends depict the colors, patterns or symbol assigned to the data series. A Legend you to assign colors to different data series.

Axis Title:
It is the title given to an axis. A 2-D graph has two axis(x and y) and a 3-d one has three(x, y and z).