How Do I Add A Pie Chart In Excel For Mac

admin



A chart shows data in a graphical format. A Pie chart is a circular chart where it divides the data into slices. Each slice represents a part of the data. Here in this post and the next, I’ll show you how to create Pie charts in Excel using your Worksheet data.

  1. This exercise was done completely in Mac Excel 2016, and other than not knowing a few of the shortcuts I use everyday, it was not very different from working in Windows Excel 2016. Dynamic Charts in Excel. It’s pretty easy to set up data and create a chart in Excel. But once you’ve created a chart, it keeps plotting data from the same cells.
  2. Once you have the data in place, below are the steps to create a Pie chart in Excel: Select the entire dataset; Click the Insert tab. In the Charts group, click on the ‘Insert Pie or Doughnut Chart’ icon. Click on the Pie icon (within 2-D Pie icons). The above steps would instantly add a Pie chart on your worksheet (as shown below).
Create
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.

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.

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

Add

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.

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.

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.

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.
How do i add a pie chart in excel for mac using

How Do I Add A Pie Chart In Excel For Mac Shortcut

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.

3) Close the window.

← PreviousNext →

Add Or Remove Titles In A Chart - Office Support


Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.

Charts are a strongpoint in Excel for Mac 2011. Students, businesses, scientists, news organizations, economists, and many other groups use charts. When you make charts in Office 2011 for Mac, you find a brand-new set of Chart tabs on the Ribbon that guide you with the latest Microsoft charting technology.

If you have some data to chart, by all means use it as you go through these examples. Typing in the data was the hard part. Now for the easy part: making the chart!

How Do I Insert A Textbox Over A Picture In Onenote? I ...

  1. Select a cell in the data range.

  2. On the Ribbon’s Charts tab, go to the Insert Chart group and then choose a chart type.

    A palette displays, showing various subtypes of charts. Choose one you think will display your data well. Excel figures out the boundaries of the data range and instantly displays your chart. To follow with the example, choose Line→2-D Line→Marked Line.

Help With Excel; Unable To Create Pie Chart With Mac ...

If the chart looks wrong, chances are Excel’s guess about which rows and columns to use for the axis was wrong. It’s a 50-50 proposition. To fix this problem, on the Ribbon’s Charts tab, locate the Data group and choose whichever Switch Plot button is not selected to switch row and column data source.

How To Insert A Pie Chart In Excel On Mac

When you select a chart, the Chart menu activates, the data range is highlighted, and you have three extra tabs on the Ribbon to enjoy: Charts, Chart Layout, and Chart Format. You can right-click individual chart elements like series, plot area, legend, and so on to display pop-up menus that lead to more formatting options. If you’re into designing great-looking stuff, welcome home!