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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920