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

Pie chart (or graph) in Excel


Excel Excel 
Ratings:
1 Comment(s)
 2738  View(s)
Rate this:

Pie chart (or graph) in Excel

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


Nice Article

By Pravesh Singh on   3 years ago
Nice Article for beginners . keep posting Avadesh Patel

Don't want to miss updates? Please click the below button!

Follow MindStick