How to create chart in excel |How to use bar,column,line and pie chart in MS excel | How to make graph in MS execel | create pie chart in excel
How to use bar,column,line and pie chart in MS excel
How to make graph in MS execel | create pie chart in excel | How to create chart in excel
In this article by HavePrasad you will
Learn how to use bar,column,line,pie chart in MS excel
Important/Note : This is an on- demand post , I love using computers and its application and know a lot about computers and Microsoft programs .You can request/demand for queries ,doubts if you face any problem . You too can ask for a post related to computers , Microsoft Applications, science,technology,history or anything else by contacting us through the contact form or through mail care.haveprasad@gmail.com
INTRODUCTION
MS Excel 2016,2013 , 2007,2000 are some of the popular spreadsheet from Microsoft, designed for the networked office environment. Spreadsheets are used in areas that involve complex calculations and analysis Spreadsheets are also known as Worksheets. They display data in the form of rows and columns Data is entered in a cell, which represents the intersection of a row and column.
This stage spreadsheet is used to learn how a bar or other kinds of graphs are plotted for two different variables.
What are spreadsheets ?
SPREADSHEETS
Spreadsheets are used in areas that involve complex calculation and analysis. These packages provide extensive Mathematical Functions that can be used for various tasks in both business and scientific areas. Spreadsheets, also known as Worksheets display data in the form of rows and columns. Data is entered in a Cell, which represents the intersection of a row and column.
Some of the popular spreadsheet packages are MS-Excel, Lotus 123, Supercalc, Visicalc.
Getting started with MS excel
Starting Ms excel : open Ms excel by clicking at the start button ,followed by program option.
A workbook will appear on the desktop.
Start your work !
MINIMUM REQUIREMENTS
MS Office 2000 or any and Windows 98or any on to the computer.
STEPS TO BE FOLLOWED
1. Click at the 'start' button provided at the extreme left hand side at the bottom of the desktop.
2. Go to Program option and then on to MS Excel option.
3. A menu with some options and a worksheet appears on the desktop.
4. Create a spreadsheet showing details of the number of visitors at two hotels from different countries for three years as per the following data and save the spreadsheet as hotel.xls.
For example
Lakeview hotel and country club
Nationality 1998 1999 2000
French 1238 968 627
Japanese 395 483 597
Australian 650 793 934
German 994 854 699
American 937 1108 1405
Others 786 794 756
5. Select all the rows and columns started from French. Go to Data mode from the main menu and then to Sort option. Choose Ascending order. It will convert all the visitors in alphabetical order with reference to countries. 6. Then again from the main menu go to the insert' mode and select chart option.
Choose column or bar; line' and 'pie' in three different trials. A graph with three years series appears on the monitor. You can change the series option. For example, with years as 1998, 1999, 2000. You can also label the x-axis and yaxis. The caption can also be given to these graphs. Save them as hotel 1.xls. hotel2.xls, and hotel3.xis in different files in the test folder already created in the hard disk.
PROGRAM SAVED AS
C: Test hotel.xls
C: Test\hotel1.xls
C: Test\hotel2.xls
C: Test\hote13.xls
OUTPUT
The different kinds of graphs are shown in the image provided below , for the column, line and pie options.
 |
| MS excel : column graph |
 |
| MS excel : line graph |
 |
| Ms excel : pie chart |
Conclusion
This is an end to the topic ,Microsoft excel could be used in various flields. Therefore it is important to know about its function, its option etc. Graph,pie chart,line graph could be used in various projects,presentations, and could make your work look more impressive and nice . For any doubts refer to the comment section .
