Skip to main content

MS Excel: To create charts

MS Excel: To create charts

Ms Excel provides us different type of  charts which can be used according to the demand of data.
Following type of charts can be used in ms excel:

Pie Chart: It is used to express data in the form of percentage.



Bar Chart:  It is used if we want to compare different values related to different categories.It runs horizontally as shown in fig below:



Column chart: It is similar to Bar chart, however it runs vertically as shown in below diagram:



Line Chart:   To show trend of  data over a span of time this kind of chart is used:



Example: Lets us understand how to insert a chart in MS excel with an example. Consider we have a following data in the form of table and we want to display it in the form of chart.



To display it in the form chart:
  • Select the data
  • Click on 'Column' under 'Insert' tab to select 'Column chart'
  • Select the chart type to insert the chart








Labels:

Comments

Post a Comment

Popular posts from this blog

MS Excel- For beginners

Lets learn basic things about MS- excel. Very first question, What is it? Ms-Excel is a spreadsheet program developed by Microsoft.Using this we can manipulate, format or calculate various arithmetic functions on data arranged in columns and rows.It looks like below: MS Excel basically consists of rows and columns. Rows :  Rows consists of horizontal lines, two parallel horizontal lines make a row as shown in fig below:   Here first row is selected. Number 1 represent row number 1 and similarly each number represents respective row number. Columns: Columns consists of vertical lines, two parallel vertical lines make a column as shown in fig below:   Each column is identified by a different alphabet as first column is marked as A.  Cell : A cell is a rectangular box which occurs as the result of intersections of rows and columns as shown below:               How to perform various arithmetic...
1 comment
Read more

Ms Excel: Merge cells and Sort/Filter

Merge & center: It is very easy to merge cells and align the text in center in Ms Excel. To do it, select the number of cells which you want to merge and click 'Merge&center' option from the 'Home' tab.This will merge the cells and align the text to the center. To un-merge the cells just click 'Merge&center' option once again. Sort and Filter: Sort: To sort the values, first select the cells which you want to sort , then select 'Sort&Filter' option from the 'Home' tab and click on 'Sort A to Z' or 'Sort Z to A' according to your need. Moreover you can click on 'Custom Sort' to try more options. For example, to sort the student list in alphabetical order, click on 'Sort A to Z', it will sort the values. Filter: To filter the data in Ms excel ,first select the column which you want to filter and  use 'Sort & Filter' option from the 'Home' tab and click on 'Filter' option.I...
Post a Comment
Read more