Add a Data Table to a Chart in Excel

You can add a data table to the most common types of charts in Excel, including bar, column, and line. Create your chart as you normally would. When you’re ready to add the data table, select the chart.

• Go to the Chart Design tab that displays and click the Add Chart Element drop-down menu in the Chart Layouts section of the ribbon.
• Move your cursor to Data Table and then choose the type of table you want to add from the pop-out menu. You can choose a table with or without legend keys.

• Move your cursor to Data Table and then choose the type of table you want to add from the pop-out menu. You can choose a table with or without legend keys.

In Excel on Windows, you have an additional way to insert a data table. Click the Chart Elements button (+) on the top right or left corner of the chart. Check the box for Data Table and select the arrow to pick the type of table you want to use.

Once you add your table, you may need to resize your chart by dragging a corner or edge. This helps you give the chart and data table more room which makes them both easier to read.

If you decide later to remove the table, return to Chart Design > Add Chart Element and pick “None” in the Data Table pop-out menu.

Customize a Data Table in Excel

By default, a data table appears in a grid with borders and a white background. But you can customize the appearance of the table if you like.

• Select the chart, click the Add Chart Element drop-down menu, and move to Data Table. Select “More Data Table Options” in the pop-out menu.

When the Format Data Table sidebar opens, confirm that you’re on the Table Options tab. Then, expand the Data Table Options section to see the borders.

You can check or uncheck the boxes to use horizontal, vertical, or outline borders. If you change your mind about the legend keys, check or uncheck the Show Legend Keys box.

• To change the fill and border settings, select the Fill & Line tab. You can choose a fill type and pick a color from the palette.
• You can do the same thing for the borders directly beneath the data table, plus you can change the border width, line type, transparency, and other settings.
• If you’d like to spruce up the data table with a shadow, glow, soft edge, or 3-D effect, head to the Effects tab. Here, you can experiment with different looks for your data table.

You can also change the font that displays within the table. At the top of the sidebar, choose Text Options. Use the Text Fill & Outline and Text Effects tabs to adjust the text fill style, font color, transparency, and effects.

When you change the source data that appears in the chart, your chart will automatically update. The same goes for the data table within the chart.