Скачать или смотреть How To Create Insert Make A Basic Pie Chart (Graph) With Numbers Or Values In Excel Explained

In this video we discuss how to make, insert or create a basic pie chart or graph in an excel worksheet. We go through a detailed example step by step and also show how to insert numbers or values in the chart

Transcript/notes
To make a basic pie chart in excel, you need to have labels in a column and data for those labels in a column, such as in this example worksheet, where I have departments and sales for each of those departments.

From here, left click and hold and drag over all of the labels and data, so here, cell A2, over to cell B7, then release the click and hold so the cells are highlighted. Next, make sure you are on the insert tab near the top of the worksheet. Then, in the charts area near the top of the worksheet, left click on the down arrow next to this pie chart icon, and a drop down box will appear with some options. If you hover over these, you will see a preview of the different pie charts. I am going to select a basic 2D chart, by left clicking on the icon.

From here, you can left click and hold in an open area on the chart a move the chart to a desired location. Next, if you left click on the title text, you can change the title, as you see I am doing here. To edit the chart, left click on the Chart Design text near the top of the worksheet, and a new ribbon will appear, where you can make modifications.

I am going to left click on the down arrow in the add chart element icon and hover over data labels, and left click on Outside End to put values on each of the pie sections. And then I am going to go over in the chart styles section and left click on the dark background icon to give the chart a little bit of style. And that is how to create a basic pie chart in excel.

Chapters/Timestamps
0:00 How to set up for a pie chart
0:11 How to make a pie chart in excel
0:55 How to change the title
1:01 How to edit the chart, add labels