PowerPoint Chart Data Labels - Format Number Options in Excel 2011 for Mac
Learn how to format numbers used as Chart Data Labels using Excel in PowerPoint 2011 for Mac.
Author: Geetesh Bajaj
Product/Version: Microsoft PowerPoint 2011
OS: Mac OS X
In PowerPoint even though you can use Category or Series names as Data Labels, most of the time users tend to use Values as Data Labels. Values are typically numbers, and there are many ways in which you can format these Data Labels. You may want to do so for several reasons such as limiting or expanding the number of decimal digits shown, or to show a currency symbol along with the values, or even to show the value in percentage etc. Figure 1 shows a sample chart with values added as Data Labels with no changes made as yet. Do note that these format changes can be made both within Excel and PowerPoint -- in this tutorial, we explore how you do so in Excel at the data level (all data for PowerPoint charts resides in Excel). In the next tutorial of this series, we will show you how you can achieve similar results within PowerPoint.
Figure 1: Chart with Data Values added as Data Labels
Follow these steps to learn how to format the values used in Data Labels within Excel 2011:
- Select the chart -- then select the Charts tab which appears on the Ribbon, as shown highlighted in red within
Figure 2. Within the Charts tab, click the Edit button (highlighted in
blue within Figure 2) to open the Edit menu. Within the Edit
menu, select the Edit Data in Excel option as shown in Figure 2.
Figure 2: Edit Data in Excel option
- This opens your chart data within
Excel as shown in Figure 3.
Figure 3: Chart data opened within Excel
- Now, select all the data values, as shown in Figure 4.
Figure 4: Data values selected
- Right-click the selected data to access a contextual menu as shown in Figure 5 -- from this contextual menu,
select the Format Cells option (refer to Figure 5 again).
Figure 5: Format Cells option within the contextual menu
- This will summon the Format Cells dialog box. Make sure that the Number tab (highlighted in
red within Figure 6) is selected so that you can view the number format options that you can see in
Figure 6: Number format options within the Format Cells dialog box
Out of various formats that you can see within Category list in Figure 6, the most commonly used ones are Number, Currency, Accounting, and Percentage. Let us explore these options one by one:
- Number: This Category is used to display the numbers in general format. The options that you get within Number
format, as shown in Figure 6, are:
- Decimal places: You can decide the number of decimal places you want to show in the Data Labels. Type within the
box the number of decimal places to be shown, or use the up and down arrows.
- Use 1000 Separator (,): Select this check-box to use a comma to group the digits of Data Values in thousands.
- Negative numbers: Here, select a format in which you want the negative values to be displayed.
- Decimal places: You can decide the number of decimal places you want to show in the Data Labels. Type within the box the number of decimal places to be shown, or use the up and down arrows.
- Currency: This format is used to display monetary values. Here you will find Decimal places,
Currency symbol, and Negative numbers options, as shown in Figure 7.
Figure 7: Currency format options within the Format Cells dialog box
Decimal places and Negative numbers options work similarly as they do with Number format. Currency symbol selection box (highlighted in red within Figure 7, above) provides you with various currency symbols to be shown as part of Data Labels.
- Accounting: Formats the Data Labels to include the currency symbol and also specified number of decimal digits.
- Percentage: Multiplies the values by 100 and displays the results along with a percentage symbol and specified number of decimal digits, as Data Labels.
- Number: This Category is used to display the numbers in general format. The options that you get within Number format, as shown in Figure 6, are:
- Select options as required. When done, click the OK button to get back to your data sheet. Now you can see that
the selected values within the data sheet are formatted based on the selections we made. In Figure 8, you can see our
sample data sheet after we formatted the cells (compare Figures 4 and 8).
Figure 8: Data values formatted within Excel sheet
- Navigate back to your PowerPoint slide -- now you will see that the Data Labels reflect the formatting done within Excel, as shown
in Figure 9 (compare with Figure 1).
Figure 9: Data Labels reflecting the formatting done within Excel
Note: All values, including the Values axis now reflect the changed formatting, and this change is not restricted to just the Data Labels, as you can see in Figure 9 above. To counter this all-or-nothing approach, you can format the Data Labels in PowerPoint itself, as explained in our Chart Data Labels - Format Number Options in PowerPoint 2011 for Mac tutorial.
- Save your presentation.
If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.
This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.
Check the book on Amazon.com...