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: 5 most useful shortcuts

 MS Excel: 5 Most useful shortcuts in Excel 1. Shift+space : This shortcut is used to select the single entire row . Hold down the shift key and use up/down arrows to select multiple rows. 2. Ctrl+ space : This shortcut can be time saving to select an entire column . Hold down the shift key and use left/right arrows to select multiple columns 3. Ctrl+T : This is used to quickly insert the table . It would ask where the data is for your table before creating the table. 4. Ctrl+9 : It can be used to hide rows  in a worksheet.Note, hidden rows will not be printed. 5. Ctrl+0 : This is helpful in hiding the columns in a worksheet. Note,hidden columns will not be printed.  Click here to learn about Charts in Excel
Post a Comment
Read more

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