How to create a Pie Chart in Excel
How to create a Pie Chart in Excel
Learn how to create a Pie Chart in Microsoft Excel. This tutorial talks about what a pie chart is and then demonstrates how to create a simple Pie Chart in Excel with easy to follow steps.
Create a Pie Chart in Excel (and sample data):
https://www.techonthenet.com/excel/ch…
Excel Charts:
https://www.techonthenet.com/excel/ch…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0 -> A pie chart is a type of graph in Excel
that is represented by a circle divided into slices
6.68 -> You can use a pie chart
when you have one series of data
11.46 -> and you want to show your data
as a proportion of the whole
15.04 -> With a pie chart, all of the
slices add up to 100%
18.92 -> To illustrate how to create a pie chart,
let's look at an example
23.58 -> Here we have a table of data
containing Sales by Division
28.28 -> Let's use a pie chart
to graph this information
31.67 -> To get started, highlight the data
that you would like to use for the pie chart
36.92 -> In this example, we have
selected the range A1:B5
41.72 -> Next, select the Insert tab in
the toolbar at the top of the screen
47.66 -> Click on the pie chart button
in the Charts group
50.24 -> and then select a chart
from the drop down menu
53.38 -> As you hover over each choice
in the drop down menu
56.68 -> it will show you a preview of your data
in the highlighted chart format
61.04 -> In this example we will select
the first pie chart in the "2-D Pie" section called "Pie"
67.06 -> The chart will now appear
in the spreadsheet
69.92 -> To move the chart, just left-click and drag
it to the desired location in the sheet
75.12 -> As you can see, our pie chart
has four slices
79.558 -> One slice for each division
82.22 -> Each slice represents the sales as a
percentage of the total sales
87.54 -> In this example, the North division
has the largest slice
92 -> This completes our example of
how to create a pie chart in Excel
96.52 -> If you would like to
see more examples of charts
98.84 -> or would like to download
the sample data we used for this tutorial
102.34 -> please visit our website at
TechOnTheNet.com
105.38 -> If you have found our tutorial helpful,
please leave a like on this video
109.88 -> and don't forget to subscribe to our
YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=wIt5K3Uu8kA