Skip to main content

Creating a Pie Chart in Microsoft Excel Tutorial With Pictures

Why Do We Use Excel Pie Charts?

Excel Pie Charts are used in a Microsoft Excel Worksheet to display the contribution of each cell value to the total value. Today, we will discuss the procedure of creating a Pie chart in Microsoft Excel. Start Microsoft Excel and perform the following steps as explained with the help of nice clear pictures.
Create Pie chart in MS Excel in easy practical steps
Creating Excel Pie Charts Easy Tutorial With Pictures

Steps To Create Pie Chart in Excel


1. Prepare Example Excel Worksheet For Pie Chart

Start Microsoft Excel with a new blank workbook. Microsoft Excel is a part of Microsoft Office.
Prepare a new Excel Worksheet as shown in the figure below to show Serial Numbers, Batsman and their Scores got in a cricket match. Fill in the sample data as you wish.

2. Select Cell Range To Prepare Excel Pie Chart

Select The Two Columns named Batsman and Scores with filled values and column titles, as shown in the figure above.

3. Use Insert Tab To Create Pie Chart

Click on Insert Tab and click on Pie Chart tool. Select a suitable type of Pie Chart, say we select the very first type from 2D pie charts. When you will click on this type of pie chart, the Pie Chart will be crated and shown in the you Excel worksheet as shown below.
Creating Excel Pie Charts Easy Tutorial With Pictures
Steps to create a PIE Chart in MS Excel

Making and Showing Excel Pie Charts
Explain the use of Pie Charts in Excel spreadsheet software

4. Changing Layout of Excel Pie Chart

You can change the layout of your Pie chart easily by selecting a suitable layout on Chart Tools as shown in the figure below
Changing Layouts of Pie Charts in Excel

5. Getting the Final Excel Pie Chart

As soon as you click on your selected layout, the Pie chart will be changed to new layout look as shown in the figure below.

How To Prepare an Excel Pie Chart
Thank you for coming and staying with us at Www.ForFreeEducation.Blogspot.Com a totally free blog for Perfect Computer Notes and much more.

You may also like to read:

Electricity Bill Calculator Formulas in Excel 
Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals

Labels:

Comments

Unknown said…
Your blog is one of a kind, i love the way you organize the topics.:’-”‘
more read Case Study Assignment Help
October 13, 2016 at 2:41 PM
Unknown said…
Just added your blog to my list of value reading blogs get more info Assignment Help

November 5, 2016 at 12:20 PM
Post a Comment

Popular posts from this blog

Convert Centimeters to Inches Python Programming | Python Program Conver...

YouTube Video Tutorial How to write a Python program to convert centimetres to inches Formula to convert centimetres to inches   Explanation of this Python Program This Python program prompts the user to enter a height in inches, converts it to centimeters, and then prints the converted value. It uses the conversion factor of 2.54 to perform the conversion and rounds the result to two decimal places before displaying it to the user. Here's an explanation of the provided Python program line by line: python inches = float ( input ( 'Enter the Height in inches to convert into centimeters:' )) This line prompts the user to enter a height in inches and assigns the entered value to the variable inches . The input() function is used to receive input from the user, and float() is used to convert the input into a floating-point number. python centimeters = inches * 2.54 This line calculates the equivalent value in centimeters by multiplying the inches variable by the conver...
Post a Comment
Read more

Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

Topics covered with examples: Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa Number Systems in Computer Science and Conversion Method Conversion of Decimal number system to other  number systems Conversion of Decimal number system to binary number systems Conversion of Decimal number system to octal number systems Conversion of Decimal number system to hexadecimal number systems Conversion of    non-decimal Number system to Other non-decimal number system Conversion of other number systems to Decimal number system Conversion of binary number systems to Decimal number system Conversion of octal number systems to Decimal number system Conversion of  hexadecimal number systems to Decimal number system Q1. What is a Number System? What are different types of number system? Number system A number system is a set of digits, symbols and rules to express quantities in counting and c...
Post a Comment
Read more

Find Your Correct Age From Date of Birth

First of all click on First two digits to type Month number from keyboard like any number from 1 to 12. . Now click on next two digits and type day number of month that is date from 1 to 31. In the last step type the year of your birth in four digits like 1995.  Now click on the blue button with text "Calculate Age". Your accurate age will be displayed below the button. For example. If today is 09-16-2023 that is September 16, 2023 and you type birth date as 11-01-2000 that is November 1, 2000, your accurate age will be displayed as:Your age is 22 years, 10 months, and 15 days. Age Calculator Age Calculator Calculate Your Age Now! Enter your date of birth: Calculate Age As shown in the image below:
Post a Comment
Read more