How to Create a Chart in Excel

In this article, WikiHow will show you how to create visual data visualizations in Microsoft Excel using pie charts.

Table of Contents

More data

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/02/Make-a-Pie-Chart-in-Excel-Step-1-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/02/Make-a- Pie-Chart-in-Excel-Step-1-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-1-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the Microsoft Excel program. This program has an icon that looks like a white “E” on a green background.

If you want to create a chart from existing data, double-click the Excel document containing the data to open it and proceed to the next step.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e5/Make-a-Pie-Chart-in-Excel-Step-2-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e5/Make-a- Pie-Chart-in-Excel-Step-2-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-2-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}

Click on Blank workbook – Blank workbook (for PC) or Excel Workbook (for Mac). This button is located at the top left of the “Template” window.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5e/Make-a-Pie-Chart-in-Excel-Step-3-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5e/Make-a- Pie-Chart-in-Excel-Step-3-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-3-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}

Add a name to the chart. To add a name to the chart, click in cell B1 , then enter the name of the chart.

For example, if you create a chart for your budget, cell B1 is titled something similar to “2017 Budget”.
You can also enter a label for clarity in cell A1 – for example, “Budget allocation”.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0f/Make-a-Pie-Chart-in-Excel-Step-4-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0f/Make-a- Pie-Chart-in-Excel-Step-4-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-4-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Add data to the chart. First enter the label names for the parts of the pie chart in column A and enter the values of those parts in column B .

For the budget example above, you could write “Car expenses” in cell A2 and then enter “1000 USD” in cell B2 .
The pie chart templates will automatically determine the percentages for you.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Make-a-Pie-Chart-in-Excel-Step-5-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Make-a- Pie-Chart-in-Excel-Step-5-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-5-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}

Complete the data entry process. Once you’ve completed this process, you’re ready to chart your data.

Create a chart

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/41/Make-a-Pie-Chart-in-Excel-Step-6-Version-3.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/41/Make-a- Pie-Chart-in-Excel-Step-6-Version-3.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-6-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Select all data. To select, click in cell A1 , hold down ⇧ Shift , and then click the bottom value in column B . So you can select all the data.

If your data is in columns marked with letters, numbers, etc. otherwise, click the top left cell in the data group and then click the bottom right cell while holding down ⇧ Shift .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Make-a-Pie-Chart-in-Excel-Step-7-Version-2.jpg/v4-728px- Make-a-Pie-Chart-in-Excel-Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/85/Make-a- Pie-Chart-in-Excel-Step-7-Version-2.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-7-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the Insert tab. This tab is at the top of the Excel window, just to the right of the Home tab.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4e/Make-a-Pie-Chart-in-Excel-Step-8.jpg/v4-728px-Make-a- Pie-Chart-in-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4e/Make-a-Pie-Chart-in-Excel- Step-8.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :550,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the “Pie Chart” icon. This icon is the round button in the “Charts” options group, just below and to the right of the Insert tab. You will then see several options appear in the drop-down menu:

2-D Pie – Create a simple pie chart showing color-coded sections of data.
3-D Pie – Uses a three-dimensional pie chart that displays color-coded data.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ea/Make-a-Pie-Chart-in-Excel-Step-9.jpg/v4-728px-Make-a- Pie-Chart-in-Excel-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ea/Make-a-Pie-Chart-in-Excel- Step-9.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight” :545,”licensing”:”<div class=”mw-parser-output”></div>”}

Click an option. This helps to create a pie chart based on existing data; you’ll see color-coded tags at the bottom of the chart that correspond to the colored parts of the chart.

You can preview the options here by hovering over the different chart patterns.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b6/Make-a-Pie-Chart-in-Excel-Step-10.jpg/v4-728px-Make-a- Pie-Chart-in-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b6/Make-a-Pie-Chart-in-Excel- Step-10.jpg/v4-728px-Make-a-Pie-Chart-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :550,”licensing”:”<div class=”mw-parser-output”></div>”}

Customize the look and feel of the chart. To customize the look, click the Design tab near the top of the “Excel” window, then click an option in the “Chart Styles” group. This will change the look of your graph, including the colors used, how the text is distributed, and whether or not the percentage is visible.

To view the Design tab, you must select the chart by clicking on it.

Advice

You can copy the chart and paste it into other Microsoft Office products (such as Word or PowerPoint).
If you want to create charts for multiple groups of data, repeat this process for each group. Once the chart is displayed, click and drag the chart out of the center area of the Excel document to prevent the latter from overlapping the previous one.

Steps

More data

Create a chart

Advice

Related Posts