How to Format the X and Y Axis Values on Charts in Excel 2013
Create a Histogram with a Pivot Table for Excel Dashboards
How to Create Charts via the Quick Analysis Tool in Excel 2013

How to Add Data Tables to Charts in Excel 2013

Sometimes, instead of data labels that can easily obscure the data points in the chart, you’ll want Excel 2013 to draw a data table beneath the chart showing the worksheet data it represents in graphic form.

To add a data table to your selected chart and position and format it, click the Chart Elements button next to the chart and then select the Data Table check box before you select one of the following options on its continuation menu:

  • With Legend Keys to have Excel draw the table at the bottom of the chart, including the color keys used in the legend to differentiate the data series in the first column

  • No Legend Keys to have Excel draw the table at the bottom of the chart without any legend

  • More Options to open the Format Data Table task pane on the right side where you can use the options that appear when you select the Fill & Line, Effects, Size & Properties, and Table Options buttons under Table Options and the Text Fill & Outline, Text Effects, and Textbox buttons under Text Options in the task pane to customize almost any aspect of the data table

The figure illustrates how a clustered column chart looks with a data table added to it. This data table includes the legend keys as its first column.


If you decide that having the worksheet data displayed in a table at the bottom of the chart is no longer necessary, simply click to deselect the Data Table check box on the Chart Elements menu.

blog comments powered by Disqus
How to Create Side-by-Side Time Comparisons in Excel Reports
Use Excel Pivot Tables to Get Top and Bottom Views
Create a Bullet Graph for Your Excel Dashboards
Use Histograms to Track Frequency in Excel Dashboards
How to Save a Customized Chart as an Excel 2013 Template