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

Explain different types of storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...
3 comments
Read more

Important objective type questions 1-50

FTP stand for     file transfer protocol. Lady ADA is the mother of computer.    VINT CERF     is the father of Internet. Nibble consists of   4   bits.   Google     and   Yahoo   are the two search engines. TCP/IP stands for Transmission control protocol/Internet protocol. One sector on Hard Disk holds   512    bytes.   Dos, window and UNIX are three operating systems. Demodulation converts Analog signal into Digital signal. ARPANET stands for advanced research project agency network. URL stands for uniform resource locator . Charles Babbage is the father of computer. Lady ADA is the first computer programmer. Nibble contains 04 numbers of bits. Name Two Mail service mail Yahoo.com. VOIP stands for Voice over internet protocol. One sector holds 512 numbers of bytes. N...
Post a Comment
Read more

Definition and History of ECommerce

What do you mean by E-Commerce? Electronic Commerce (e-Commerce) is a general concept covering any form of business transaction or information exchange executed using information and communication technologies (ICTs). e-Commerce takes place between companies, between companies and their customers, or between companies and public administrations. Electronic Commerce includes electronic trading of goods, services and electronic material. BRIEF HISTORY OF E-COMMERCE + E-commerce started in early 1970’s with invention of electronic fund transfer(EFT). + Only used by large organizations, financial institutions and a few small business at that time. + After invention of EDI (Electronic Data Interchange) from financial institutions to manufacturers retailers, services and so on. + Many other e-commerce applications started from stock trading to travel reservation system. + With commercialization of internet in early 1990’s. The term electronic commerce was used. Interne...
Post a Comment
Read more