Microsoft Office

Chart in MS-Excel

Chart in Ms Excel

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 
Types of Chart
  • 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.
Column Chart
  • 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.
Line Chart
  • 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.
Pie Chart
  • 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.
Bar Chart
  • 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.
Area Chart
  • 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.
Scatter Chart
  • 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.
Stock Chart
  • 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.
Surface Chart
  • 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.
Doughnut Chart
  • 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.
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.
Radar Chart
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.

Creating Chart 

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. 

You can also join us at QUORA

About the author

Pooja Rastogi

Leave a Comment