Copy a bunch of Excel cells into PowerPoint or even create a table within PowerPoint itself and type in some data. This is something that can be difficult for most audiences to comprehend because figures don't show any trends, at least no visual trends. The solution typically is to add a chart on your slide that's based on the same data so that you can compare two or more sets of values more visually and intuitively. However, there may be times when you need to show both the chart and the underlying data. To make this possible, you can use PowerPoint's Data Table option This way, not only you get the pictorial representation of the values, but also get to show the same values in the form of a table right below the chart.
Follow these steps to learn more in PowerPoint 2011 for Mac:
- Open your presentation and select the required chart, as shown in Figure 1, below.
Figure 1: Chart selected
- With the chart selected, access the Chart Layout tab of the Ribbon, as shown highlighted in red within Figure 2, below. Then, click the Data Table button, shown highlighted in blue within Figure 2.
Figure 2: Data Table button
- Doing so brings up the Data Table gallery, as shown in Figure 3, below.
Figure 3: Data Table gallery
- Let us explore options within the Data Table gallery, as marked in Figure 3, above:
- Selected by default. as indicated by a tick mark in front, this option removes any existing Data Table from the chart. Your chart will appear as shown previously in Figure 1 on this page.
- Adds a Data Table to the chart. Figure 4 shows Data Table added to our sample chart, as shown highlighted in red within Figure 4, below.
Figure 4: Data Table added
- Works almost similar to the Data Table option except that each Series name is accompanied by its Legend Key (color block) in the Data Table, as shown highlighted in red within Figure 5, below.
Figure 5: Data Table with Legend Key
- Summons the Format Data Table dialog box that provides you with options to customize the appearance of your Data Table. This option is explained in our Data Table Options for Charts in PowerPoint 2011 for Mac tutorial.
- Save your presentation often!
A. No Data Table
B. Data Table
C. Data Table with Legend Key
D. Data Table Options
Chart Data: Chart Data Table (Glossary Page)