Data tables display the chart values in a grid beneath the chart. A data table, displays at the bottom of the chart showing the actual values.ĭata tables can be added to charts on a regular worksheet, but it isn't a common practice because the worksheet itselfĪlready displays the data. Options include a choice not to show a data table, show a data tableīut not show a chart legend, or to show a data table and include the chart legend.
Make your selections from the various formatting options and click ok.Excelĭisplays the Format Data Table dialog box. To explore additional formatting options for the data table, choose More Data Table Options from the menu.Click the Data Table button and choose an option from the menu.Click anywhere on the chart and click the Layout tab to display the chart layout tools on the Ribbon.To add a data table to an existing chart, follow these steps: When youĬreate a chart, you can select a layout that includes a data table. In Excel, you can display a table of the data that you use in the chart.
