Select the “Chart Design” tab on the ribbon, click the “Add Chart Element” button, point to “Data Table,” and select the type of table you want to add. Select the “More Data Table Options” menu item to further customize your data table.
When you make a graph in Excel, you may want to include the source data with it. By adding a data table, which takes just a few steps, you can provide extra details or further explain your visual.
A data table is a grid of the data you use to create your chart that sits beneath the graph itself. Once you add a data table, you can format and customize it to your liking.
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.
RELATED: How to Make a Bar Chart in Microsoft Excel
Go to the Chart Design tab that displays and click the Add Chart Element drop-down…
Read Full Article Source
