How to make a pie chart Once your data is formatted, making a pie chart only takes a couple clicks. First, highlight the data you want in the chart: Then click to the Insert tab on the Ribbon.
- Column, bar, line, area, pie, and donut charts in Numbers on Mac. To create any type of chart, you can add a chart to a sheet first, then select the table cells with the data you want to use. Or, you can select the data first, then create a chart that displays the data. Either way, when you change the data in the table, the chart updates.
- Select the chart. Go to the Chart Layout tab. Click the Data Table button and choose a Data Table option on the drop‐down list. To format a data table, go to the Format tab and click the table data in the chart.
- With the chart selected, click the Chart Design tab to do any of the following: Click Add Chart Element to modify details like the title, labels, and the legend. Click Quick Layout to choose from predefined sets of chart elements. Click one of the previews in the style gallery to change the layout or style.
- A pie of pie or bar of pie chart, it can separate the tiny slices from the main pie chart and display them in an additional pie or stacked bar chart as shown in the following screenshot, so you can see the smaller slices more visible or easier.
The Worksheet Data
Here’s the data on my worksheet (see below image). I have four columns and five rows on sheet1, which shows some figures (sales for example) for each product. The columns are the products and each row has monthly sold units of each product.
How Do I Add A Pie Chart In Excel For Macs
Now, let’s see how we can create Pie charts using the above data.
In my first example, I want to create a Pie chart to see how many Pens, Rulers etc. I have sold in the month of April. Simply follow the steps.
1) First, select the data for the chart, like this
2) Next, from the top menu in your Excel workbook, select the Insert tab. You will see a list of chart types. Click the Pie option and choose a type, either 2D or 3D, depending on your requirement.
Your chart for the selected data is now ready.
Similarly, you can create and add another chart, say for the month of May (for all products). However, this time you will have to choose rows separately. It’s a mouse and keyboard combination. Select the 1st row using the mouse, till the last column, then press the Ctrl key, set focus on the 3rd row using the mouse and drag it till the last column.
![Chart Chart](/uploads/1/2/6/4/126465877/703996255.png)
Again, choose the Pie chart from the menu (as I have shown earlier). Repeat the process for all the rows and you have multiple Pie charts on sheet1.
Second Example
Using the same data structure, you can create a product wise Pie chart (In the above example, I have created Pie charts for different months). I wish to see the number of sales for my products (pen, ruler etc.) for every month. This is vertical selection.
Similarly, you can create another chart by choosing the next column’s data (that is ruler), along with the first column data. Click the mouse on the first column, first row and drag the mouse down until the last row. Next, hold the Ctrl key, click the 3rd column (ruler) and drag the mouse till the last row.
There are other features associated with the Pie chart, which you can use to enhance user experience.
Separate a Pie Chart Slice
You can separate a Pie chart slice (or all the slices). Double click a particular slice, hold and drag it out to separate it from the other slices. You can use this option to analyze the data.
Add or Remove Data Labels to a Pie Chart (Excel 2007)
Data labels are data (or figures) associated with each slice. The data labels make a chart easier to understand. When you insert a Pie chart on your worksheet, it will show different slices, a title and a legend, without the data labels. This is the default behavior. You will have to add or remove Data labels on your own.
See All Results For This Question
Now, see the below image again. It shows the slices, the title and the legend (apr, may etc.). The slices are the figures or the units sold (10, 20, 30 etc.). Without the data labels it is difficult to understand what each slice indicates.
To add Data labels to the chart,
1) Move the mouse over the chart for which you want to add data labels.
2) Right click the chart. It will show a small popup box. Choose the option Add Data Labels.
2) Right click the chart. It will show a small popup box. Choose the option Add Data Labels.
3) You can data label to a single slice. Simply double click the slice for which you want to add labels and repeat steps 1 and 2.
Note: Data labels will update automatically when you change the figures in your worksheet.
Note: Data labels will update automatically when you change the figures in your worksheet.
To remove Data labels from the chart,
1) Right click the chart for which you want to remove data labels. It will show a small popup box.
2) Choose option Format Data Labels. It will open another box (window) with many options.
2) Choose option Format Data Labels. It will open another box (window) with many options.
3) Close the window.
← PreviousNext →
Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.
![How Do I Add A Pie Chart In Excel For Mac How Do I Add A Pie Chart In Excel For Mac](/uploads/1/2/6/4/126465877/243238623.jpg)
How to show/add data table in chart in Excel?
Sometimes, for conveniently analyzing the data in chart, we need to combine the data table and the data chart together. Now I will tell you a way to add the data table to a chart in Excel.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Show data table in chart
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
In Excel, in the Chart Tools group, there is a function to add the data table to the chart.
1. Click on the data chart you want to show its data table to show the Chart Tools group in the Ribbon. See screenshot:
2. Click Layout > Data Table, and select Show Data Table or Show Data Table with Legend Keys option as you need. See screenshot:
Now the data table is added in the chart.
In Excel 2013, click Design > Add Chart Element > Data Table to select With Legend Keys or No Legend Keys.
Relative Articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
How To Create And Format A Pie Chart In Excel
- To post as a guest, your comment is unpublished.On my new and latest version of Excel, Chart Tools only has two subsidiary Tabs i.e. Design & Format. There is not one for Layout.
I just want to add a Legend below the horizontal data.
Please advise.- To post as a guest, your comment is unpublished.Click on your Chart>>Click on the DESIGN tab>>Click on the QUICK LAYOUT (2nd from left)>>You will find a number of layouts there to chose from.
Layout number 5 is with the Data Table.
or Alternatively
Click on your Chart>>Click on the Green + sign at the Top right of your Chart>>Tick Data Tables from there.