In this video we are going to create, edit,
and format Pie Charts in Excel.
Many charts specialize in showing one thing,
like the value of a category.
Pie charts are great for showing both a value
and a proportion for each category.
In this example, I will be using a PC, the
MAC may look a little different.
We want to create a pie chart for 2021 Product
Sales.
We only want to use the data in the product
and 2021 column.
If we want to select non-adjacent cells and
show the Product descriptions and 2021 data,
we could select the data under 2021 and then
hold down the CTRL key for PC or Command Key
for a MAC.
Notice, the non adjacent columns are selected.
For this example we are only going to select
2021 data.
On the Insert Tab, locate the pie chart icon
on the ribbon.
This is where you would decide which type
of chart you would like to create.
In this video we are creating a pie chart.
If we select the totals, notice that our pie
chart is out of proportion.
Not selecting the totals will show the pie
chart in its correct proportion.
If you need to change the data in the chart,
go to the Chart Design Tab and choose Select
Data.
Here you can add the Horizontal (Category)
Axis labels and change the series so the viewer
will know what the chart is actually showing.
We want to see the products in each category
sold for the year 2021.
It is important to add a description of the
pie chart, a legend they will understand,
and colors that show a professional chart.
To change the style of the chart, go to the
Chart Design Tab, in the Styles group choose
a different style.
Styles can enhance the the chart and make
the chart look professional.
Now let’s add a chart title.
2021 Product Sales.
There are other tools you can use to enhance
or change your Pie Chart.
To change the color of all the pieces of the
pie, go to the Chart Design Tab, Click on
Change Colors and choose a new color scheme.
In order to change the color of a slice, click
on the chart, select the individual data marker
that you want to change.
On the Format tab, in the Shape Styles group,
click Shape Fill.
Do one of the following: To use a different
fill color, under Theme Colors or Standard
Colors, click the color that you want to use.
You can also remove the legend on the chart
by simply deleting it or going to Add Chart
Elements and moving the legend somewhere else
on the chart.
To differentiate one slice and drag it out
by itself, double-click the slice and then
drag that slice away from the center of the
chart.
To resize the chart, always drag from the
corner so that the proportion of the chart
stays consistent.
Lastly, to rotate the chart, double click
on the chart.
This will open Format Chart Area on the right
hand side of the screen.
Under the Series Options, you can explode
the whole pie or Angle the first slice of
the pie.
You have just learned how to create, edit
and format a chart.
