how do i make a doughnut chart in excel 2011 for mac?

How Do I Make A Doughnut Chart In Excel 2011 ? Download Step 9
How Do I Make A Doughnut Chart In Excel 2011 ? How To Create A

How Do I Make A Doughnut Chart In Excel 2011 ? How To Create A

The following sections provide examples of how to create a custom list in Excel Preferences and from a series of cells.

If you have just one Return key that says Enter as well, press this key.

A dotted line indicates the selected cell range, and Excel automatically types the selected range into Custom Lists preferences pane.

The Import List from Cells pop-up menu displays the range you selected.

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

How Do I Make A Doughnut Chart In Excel 2011 ? Download Step 9

Add Tip Ask Question Comment Download Step 9: Save Once you are happy with your chart, Click File, scroll down to Save As, and type in a title for your work.

Add Tip Ask Question Comment Download Step 1: Collect Data First you need to collect some data and enter it into excel.

For this tutorial we counted the number of each color of mms in a sharing size bag.

Column A is the MM color and Column B is the number of that color.

Add Tip Ask Question Comment Download Step 2: Format to Percentages Once you have the data, you need to calculate some percentages.

To do this, divide the number of each color frequency by the total number MMs.

For example, the first percentage was calculated by dividing the number of green MMs (13) by the total number of MMs (40).

Next highlight all of the percentages by clicking and holding down on the first number and then dragging down your mouse until they are all highlighted.

Then click the percentage button on the Home Tab under the category Number.

Add Tip Ask Question Comment Download Step 3: Simultaneously Select After you have turned your numbers into percent, hold the Command key and select your categories in column A.

This will simultaneously select both the categories with the matching percentages.

Add Tip Ask Question Comment Download Step 4: Create the Doughnut Next, click in the Charts Tab and then click Other.

WARNING: if your categories are colors, like ours, then the colors in the chart might not match up with the colors in the legend.

Add Tip Ask Question Comment Download Step 5: Edit Sections To fix this, select a piece of your doughnut and click it twice.

WARNING: do not double click it, but click once then pause for a second and click it again.

Then click the Format Tab, go to Fill, and click on the drop down menu.

Add Tip Ask Question Comment Download Step 7: Eye Candy If youd like to make your chart bigger, you and play with the height and width by hovering your mouse over any of the coroners until you see a double-sided arrow.

When you click down on this arrow, you can now expand the chart or make it smaller.

Now that youve made your chart bigger, you might notice that your Legend entry is a little too small now.

To change this, click on it and then click on the Home Tab and under the Font category you can adjust your font size.

This is also where you can change your font and the color of the font if you please.

Add Tip Ask Question Comment Download Step 8: Add Details If you would like to be able to see the titles and percentages on your doughnut chart, click the Chart Layout Tab, Select Data Labels, and then select Category Name and Percentages.

WARNING: your labels and percentages on the chart might be too small to read.

To fix this, go back to the Home Screen Tab and readjust your font sizes.

How Do I Make A Doughnut Chart In Excel 2011 For Mac?