In Excel, you can display a table with the data used to create a chart. This table appears below the chart itself and allows you to see the exact values along with the graphical representation.
When you create a chart, you can choose a layout that already includes a data table. To add a table to an existing chart, follow these steps:
Click on the chart to display the chart tools on the ribbon.
On the Layout tab, select the Data Table button and choose the appropriate display option. The table will appear below the chart.
For additional formatting, select More Data Table Options to open the table settings dialog box. Here you can change the style, fonts, and other elements of the table.
Adding a data table
Click on the chart you want to change.
On the Chart Tools tab → Layout → Captions → Data Table, select one of the options: do not show the data table, show the table without a legend, or show the table with a legend.
Click OK — the data table will appear below the chart, showing all values in the grid.
Data tables can be added to charts on a regular Excel sheet, although in practice this is not done often, since the sheet itself already displays the source data. However, the table is useful if you need to see exact values, for example, when working with 3D charts.
Displaying data labels
Click on the chart to modify it.
On the Layout tab → Data Labels, select the label placement option. For example, you can place labels outside the end of a column or line.
For additional settings, select More data label options, where you can change what is displayed in the label: series value, category name, etc. You can also set the number format and other parameters.
Selecting a chart color scheme
Click on the chart to change its style.
On the Design tab → Chart Styles, click the More button to open the style gallery.
Select a suitable chart theme to change the color scheme and visual appearance.
