Creation of charts

 

Charts in Excel are used to represent data pictorially. We can use different types of charts to   represent data.

 

Types of charts which are available in Excel:

1. Column charts

2. Bar charts

3. Line

4. pie

5. XY (scatter)

6. Area

7. Doughnut

8. Radar

9. Surface

10. Bubble

11. Stock

12. Cylinder, Cone & Pyramid

 

Creating a Chart :

Step

i) Enter the data in a table.

ii) Open the Insert Menu and select Chart

iii) In the Chart Wizard – Step 1 of 4, select the type of chart you want to make and click Next

iv) In the step 2 of 4, enter chart source data and click Next

vi) In the step 3 of 4, enter the chart options like label of the chart and click Next

vii) In the step 4 of 4, give the chart location where you want the chart to be located and press Finish.

excel creating chart 1

Column Chart: Column charts are one of the most common types of graphs used to display data.

A column chart represents data in the form of a series of vertical bars. Each bar represents a value.

For example, to draw a column chart for the production of different crops in a region:

excel creating chart 2

To construct a bar chart for the above data:

Step

i) Enter the data in a table.

ii) Open the Insert Menu and select Chart

iii) In the Chart Wizard – Step 1 of 4, select Column chart and click Next

iv) In the step 2 of 4, enter chart source data

v) In the step 3 of 4, enter the chart options like label of the chart

vi) In the step 4 of 4, give the chart location where you want the chart to be located and press Finish.

Excel creating chart 3

Pie Chart:

A Pie chart is used to represent the distribution of a categorical data. In this chart, a circle is divided into sectors, whose area are proportional to the frequencies or percentages of cases under various categories.

Data on each variable is entered in the Excel worksheet in a row or column with suitable headings.

Then we select the data of the first series and choose pie chart and proceed as per the options given in the dialogue box. A separate chart pie chart should be drawn for each data set.

For example, to draw a pie chart for the production of different crops in a region:

excel creating chart 4excel creating chart 5

 

 

 

 

References

http://www.austincc.edu/~emeyerth/exceltutor1.htm

http://office.microsoft.com/en-in/starter-help/introduction-to-excel-starter-HA010385336.aspx

http://www.functionx.com/excel/Lesson01.htm

http://www.gcflearnfree.org/excel

http://edutech.msu.edu/online/Excel/ExcelIntro.html

https://www.udemy.com/introduction-to-microsoft-excel/

http://chemed.chem.purdue.edu/genchem/lab/datareports/excel/intro.html

http://chandoo.org/wp/excel-tutorial/

http://www.dezyre.com/Introduction-to-Microsoft-Excel/7

http://www.slideshare.net/Shanileo/introduction-of-ms-excel

http://people.morrisville.edu/~shayyaw/Excel/IntroExcel.htm

http://www.learningtree.com/courses/1361/microsoft-excel-introduction/

http://spreadsheets.about.com/od/excel101/a/tutorial_hub.htm

http://www.teachmsoffice.com/tutorials/1/benefits-of-using-excel-overview-introduction-features

https://benchprep.com/microsoft-excel

http://www.polyu.edu.hk/its/staff_training/r_staff_01.html

http://bookboon.com/en/excel-2010-introduction-part-i-ebook#download

http://office.microsoft.com/en-in/excel-help/examples-of-commonly-used-formulas-HP005200127.aspx

 

 

 

 

 

Registration


A password will be e-mailed to you.

Feedback Form

Name (required)

Email (required)

Feedback