How to Add Data Table to a Chart

Please follow the steps below to add a "Data Table" to a Chart:

Step 1: Click anywhere on the chart, the "Design" tab will appear in the Ribbon (or the "Chart Design" tab in Excel 2019);

Step 2: In the "Design" tab, click "Add Chart Element";

Step 3: Click "Data Table" from the drop-down list, and select one of the two types "With Legend Keys" or "No Legend Keys";

Step 4: For example, the chart with the "No Legend Keys" option;

To remove the data table from the chart, click on the data table, and press "Delete" key, or repeat the steps above, and click "None" from the drop-down list.

Download Example

Leave a Reply