Sometimes, for conveniently analyzing the data in chart, we need to combine the data table and the data chart together. Now I will tell you a way to add the data table to a chart in Excel.
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
This comment was minimized by the moderator on the site
On my new and latest version of Excel, Chart Tools only has two subsidiary Tabs i.e. Design & Format. There is not one for Layout.
I just want to add a Legend below the horizontal data.
Please advise.
This comment was minimized by the moderator on the site
Click on your Chart>>Click on the DESIGN tab>>Click on the QUICK LAYOUT (2nd from left)>>You will find a number of layouts there to chose from.
Layout number 5 is with the Data Table.
or Alternatively
Click on your Chart>>Click on the Green + sign at the Top right of your Chart>>Tick Data Tables from there.