This wikiHow teaches you how to create a visual representation of Microsoft Excel data using a pie chart.
Step
Part 1 of 2: Adding Data
Step 1. Open Microsoft Excel
The program is represented by 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 desired data to open it and move on to the next segment
Step 2. Click Blank workbook (PC) or Excel Workbook (Mac)
It's in the upper-right corner of the "Templates" window.
Step 3. Add a name to the chart
To add a name, click the box “ B1 ” and type a name for the chart.
- For example, if you want to create a chart of your budget, type for example “2017 Budget” into the “ B1 ”.
- You can also type an explanatory label (e.g. “Budget Allocation”) in the “ A1 ”.
Step 4. Add data to the chart
Enter the desired pie chart segment label in the “ A ” and the value of the segments in the column “ B ”.
- For the budget example above, you can write "Car costs" in the column “ A2 ” and put "$1000" in the column “ B2 ”.
- The pie chart template will automatically determine the percentage.
Step 5. Complete the process of adding data
After completing this process, you are ready to create a pie chart using that data.
Part 2 of 2: Creating Charts
Step 1. Select all data
To select data, click the box " A1 ”, hold down Shift, and click the bottom box containing the values in the column “ B" After that, all chart data will be selected.
If the chart uses multiple columns of letters, numbers, and the like, just remember that you only need to click the farthest column at the top left of the data group and click the farthest column to the bottom right of the data group while holding down Shift
Step 2. Click the Insert tab
This tab is at the top of the Excel window, to the right of the “ Home ”.
Step 3. Click the " Pie Chart " icon (circle/pie chart)
This circle button is in the "Charts" option group, at the bottom right of the tab " Insert " You will see several options in the drop-down menu:
- ” 2-D Pie ” – You can create a simple pie chart that displays color-based data segments.
- ” 3-D Pie ” – You can use a three-dimensional pie chart that displays color-based data.
Step 4. Click options
After that, a pie chart with the selected data will be created. You can see several colored tabs at the bottom of the pie. The colors correspond to the colored segments of the chart.
You can preview the options by hovering over the different chart templates
Step 5. Modify the appearance of the chart
To modify the view, click the tab “ Design ” at the top of the " Excel " window, then click an option in the " Chart Styles " group. With this option, you can change the appearance of the chart, including the color scheme, text allocation, and the option to show/hide percentages.
To view tabs " Design ”, the chart must already be selected. You can select it by clicking on it.
Tips
- You can copy the chart and paste it into another Microsoft Office program (eg Word or PowerPoint).
- If you want to create a chart for multiple data sets, repeat this process for each set. Once the chart is displayed, click and drag the chart from the center of the Excel document outwards so that it doesn't cover/obstruct the first chart.