Excel - Creating an Excel Chart with Data Table - Episode 1625

663 views · Published 22 January 2013 · 4:58 · Indexed 21 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Set up an Excel Chart with an embedded Table.

Welcome back to the Don't Fear The Spreadsheet podcast. In this episode, we will be discussing how to set up a chart and table simultaneously, a question posed by Tyler Nash. Tyler is pressed for time and needs to know if this is possible. Unfortunately, the answer is yes, but the options available are not ideal.

To set up a chart and table simultaneously, you will need to click on the chart to access the Layout tab. From there, you can choose to show a data table or a data table with legend keys. However, these options have limited formatting capabilities and can be quite busy and overwhelming. For example, changing the number format for the data table will also affect the legend, which can be frustrating for those who like to have control over their charts and tables.

But fear not, there are other options available that will give you more control over your chart and table. One option is to choose the series layout of "Data labels> Outside End" and then format the data table to your liking. This way, the data table will be displayed on top of the chart, making it easier to read and customize. Another option is to use the existing data table that was used to create the chart and format it separately. This allows for more control over the appearance and layout of the table.

In this podcast, we will walk you through these options and show you how to create a chart and table that you can fully control. It may take a little more time than simply using the Layout tab, but the end result will be worth it. And if you want to learn more about Excel and how to conquer your fear of spreadsheets, be sure to check out our book, "Don't Fear The Spreadsheet." This book breaks down Excel in a way that even beginners can understand, making it a must-have for anyone looking to improve their Excel skills. Thanks for tuning in and happy charting!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Add a table to a Chart in Excel?
(00:24) Answer: Yes, but with limited options 
(00:36) Options for Chart and Table Simultaneously 
(01:48) Limitations and Frustrations with Data Tables 
(02:46) Alternative Options 
(04:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alternative options for displaying a table with a chart
Chart and Table
Control over data table formatting
Data table options
Don't Fear The Spreadsheet book recommendation
Don't Fear The Spreadsheet podcast episode 16
Formatting a data table
Inserting rows and moving a chart in Excel
Layout tab in Excel
Setting up a chart and table simultaneously


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153441/


Due to time constraints, Tyler needs to set up a Chart and a Table and she would like to do both simultaneously. Can it be done? Of course! It's Microsoft Excel! Follow along with Episode #1625 as Bill "MrExcel" Jelen shows us how it's done with a little available 'control' in how the final product is produced.

Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. http://www.mrexcel.com/dftss_home.html

...Also, for more on Charting and Graphs in Microsoft Excel, see the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. http://www.mrexcel.com/store/index.php?l=product_detail&p=183 

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel