Chart in MS-Excel-: There are the graphical and pictorial representation of worksheet data.Charts are usually used to analyse trends and patterns in data sets. A chart consists of following components.
- X- Axis is a horizontal axis known as category axis.
- Y- Axis is a vertical axis known as values axis.
- Data series is the set of values that you want to plot in the chart.
Types of Charts
- Column Chart:-Data that is arranged in column or rows on a worksheet can be protected in a column chart column chart are useful for showing data changes over a period of time or for illustrating comparison among items in column chart categories are typical organised along the horizontal axis and values along the vertical axis.
- Line Chart:- Data that is arranged in column or row on a worksheet can be float it in our line chart line chart can display continuous data over time set against a common is scale and are their four Idol for showing trends in data at equal interval in a line chart category data is distributed evenly along the horizontal axis and all value data is distributed is only along the vertical axis.
- Pie Chart:- Data is arranged in one column or row only on a worksheet can be plotted in a Pie Chart. Pie Chart show the size of items in one data series proportional to the sum of the writer the data points in the pie chart are displayed as the percentage of the whole Pie.
- Bar Chart:- Data that is arranged in column or row on a worksheet can be plotted in a bar chart bar chart illustrate comparison among individual item.
- Area Chart:- Data that is arranged in columns or rows on a worksheet can be plotted in a area chart. Area chart emphasise the magnitude of change over time and can be used to draw attention to the total value across a trend.
- Scatter Chart:- A chart has two value access showing one set of numerical data among the horizontal axis and another along the vertical axis it combine these value into single data point and display them in an even interval or cluster stature chart are commonly used for displaying and comparing numeric value such as scientific, statistical and Engineering data.
- Stock Chart:- Data that is arranged in column or row in a specific order on a worksheet can be floated in a stock chart as its name implies a stock chart is most often used to illustrate the fluctuation of stock prices however this chart may also be used for scientific data.
- Surface Chart:- Data that is arranged in columns or on a worksheet can be floated in a surface chart a surface charge is useful when you want to find optimum combination between two set of data.
- Doughnut Chart:- Data that is arranged in columns or rows only on a worksheet can be floated in a doughnut chart. Like a pie doughnut charge shows the relationship of cars to a hole but it can contain more than one data series.
- Bubble Chart:- Data that is arranged in column on a worksheet so that X value are listed in the first column and corresponding why values and bubble size when use are listed in adjacent column can be plotted in a bubble chart.
- Radar Chart:- Data that is arranged in columns or row on a worksheet can be floated in a rather charge rather charge compare the aggregate values on a number of data series.
Components of a Chart
- Chart Area: This is the total region surrounding the chart.
- Plot Area: The area where data is plotted. The plot area is bounded by axes in a 2D-chart where as in 3D-chart it is bounded by walls and floor.
- Chart Title: The descriptive text aimed at helping user identify the chart
- Data series: A row and columns of numbers that are plotted in a chart is called a data series.
- Grid Lines: These are horizontal and vertical lines which inserted in the chart to enhance its reliability.
- Legends: It helps to identify various plotted data series.
- Data Labels: It provides additional information about a data marker.
- Data Table: It is defined as a range of cells that are used for testing and analysing outcomes on a large scale.
Steps to creating a chart are as follows:-
Step 1:- Select the data you want to summarise visually and then click on the Insert Tab.
Steps 2:- In the Chart Groups, click the type of chart you want to create to have excel display the available chart subtypes.
Steps 3:- Then, select anyone of them by clicking it.
Steps 4:- After selecting click OK button.