How to Add a Data Table to an Excel Chart – 4 Quick Methods

Method 1 – Add a Data Table using the Chart Design Tab in Excel

1.1. Show the Data Table Using the ‘Quick Layout’ Option

Steps:

  • Click the chart and go to Chart Design > Quick Layout.
  • Choose a default chart layout that includes a data table.

Show Data Table Using ‘Quick Layout’ Option

  • You will see the chart containing the data table.


1.2. Use the ‘Add Chart Element’ Option to Show Data Tables 

Steps:

  • Click any area in the chart.

Use the ‘Add Chart Element’ Option to Show Data Tables 

  • Go to Chart Design > Add Chart Element > Data Table > With Legend Keys. You can choose No Legend Keys if you want to.

Use the ‘Add Chart Element’ Option to Show Data Tables 

  • A data table is added below the chart.

Read More: How to Add Data to an Existing Chart in Excel


Method 2 – Show/Hide a Data Table by Clicking the Plus (+) Sign in an Excel Chart

Steps:

  • Click any area in the chart and you will see the plus (+) sign at the top right corner.
  • Click the plus sign and in Chart Elements, check Data Table.

A data table will be displayed in the chart.

Show/Hide Data Table by Clicking the Plus (+) Sign of Excel Chart

  • By unchecking Data Table, you can hide the source data.


Method 3 – Add Extra Data Series to a Data Table but Not to the Chart

Steps:

  • Select the source data and go to the Insert tab.
  • Choose a charts option. 2-D Column, here.

Add Extra Data Series to Data Table but Not in  Chart

  • This is the output.

 

  • In Chart Elements, select Data Table.
  • Choose No Legend Keys.

Add Extra Data Series to Data Table but Not in  Chart

  • Right-click the column you do not want to show on the chart and choose Format Data Series.

Add Extra Data Series to Data Table but Not in  Chart

  • In the Format Data Series window, select Series Options: Fill & Line.
  • In Fill, click No fill.

Add Extra Data Series to Data Table but Not in  Chart

  • This is the output. (Extra legend key must be removed)

Add Extra Data Series to Data Table but Not in  Chart

  • Go to Chart Design > Add Chart Element > Legend > None.

  • This is the final output.


Method 4 – Format a Data Table in an Excel Chart

To format data tables:

Steps:

  • Click the chart and go to Chart Design > Add Chart Element > Data Table > More Data Table Options.

Format Data Table in Excel Chart

  • In the Format Data Table window, selected your format.


Download Practice Workbook

Download the practice workbook here.


Further Readings


<< Go Back to Data for Excel ChartsExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo