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 Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...
10 comments
Read more

Explain Different Types of Data Processing and Advantages Disadvantages

Today we will discuss different types or levels of data processing in detail. Let us define Data processing first. DATA PROCESSING Data processing is the sequence of operations performed on data to convert it into useful information . These operations may be arithmetic, statistical or logical operations. We can arrange or classify data. We can send and receive data from one point to another. Explain different types of data processing TYPES OF DATA PROCESSING (OR) LEVELS OF DATA PROCESSING) There are three types of data processing . 1) Manual data processing 2) Mechanical data processing 3) Electronic data processing We may also use the term Levels of data processing. First level of data processing was manual data processing when there were no calculating devices (before the invention of calculators). Therefore all processing jobs were performed manually by hand with the help of pen , paper and mind. In second level of data processing, machines like calculat...
2 comments
Read more

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1.    LAN - Local-Area Network 2.    WAN - Wide-Area Network 3.    MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...
Post a Comment
Read more