articles

Home / DeveloperSection / Articles / Pie chart (or graph) in Excel

Pie chart (or graph) in Excel

AVADHESH PATEL5452 29-Mar-2013

Pie chart used to display data in pictorial format.  In another words pie chart used to show data in percentages. Steps are given below

Note:
  •   Don't leave blank rows or columns when entering your data.
  •   A pie chart is a percentage chart, so only one series of data will be used in the chart. If there is more than one column of data, try to list the data to be used in the chart next to the column containing the list of names in order to simplify creating the chart. 

Step 1: First create excel sheet with some dummy data as below 

Pie chart (or graph) in Excel

Step 2: Now select data which you want to display into graph. Here I have selected rage of data from B6:C11. Now select pie chart option from “Insert” tab as below image

Pie chart (or graph) in Excel

Step 3: After selecting pie chart option, chart will be display as below

Pie chart (or graph) in Excel

Step 4: If you change style of pie chart then select pie chart (which you created in step 2) and chose formatting tab according your choice.

Pie chart (or graph) in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By