www.dummies.com Open in urlscan Pro
2606:4700::6812:537  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Toggle navigation
Search
 * Please fill out this field.


 * Browse Topics
   
   
   LIVE
   
    * Consumer Electronics
    * Food & Drink
    * Games
    * Health
    * Personal Finance
    * Home & Garden
    * Pets
    * Relationships
    * Sports
    * Religion
   
   
   LEARN
   
    * Art Center
    * Crafts
    * Education
    * Languages
    * Photography
    * Test Prep
   
   
   WORK
   
    * Social Media
    * Software
    * Programming
    * Web Design & Development
    * Business
    * Careers
    * Computers

 * Dummies on Amazon
 * Custom Solutions

 *  * Please fill out this field.

IN THIS ARTICLE

 * Introduction
 * 1Click anywhere on the chart you want to add a data table to.
 * 2On the Chart Tools Layout tab, click the Data Table button in the Labels
   group.
 * 3Make a selection from the Data Table menu.
 * 4Click OK.
 * About the Book Author

 1. 
 2. Software
 3. Microsoft Office
 4. Excel
 5. How to Add a Data Table to an Excel 2010 Chart


HOW TO ADD A DATA TABLE TO AN EXCEL 2010 CHART

In this article
AddThis Sharing Buttons
Share to FacebookFacebookShare to TwitterTwitterShare to LinkedInLinkedInShare
to EmailEmail

By Diane Koers

In Excel 2010, data tables display the chart values in a grid beneath the chart.
They are helpful if you need to see exact values along with a graphical display,
such as when using a 3-D chart. Also, they may be preferable to data labels,
which can be difficult to read within some charts.


1CLICK ANYWHERE ON THE CHART YOU WANT TO ADD A DATA TABLE TO.

Data tables can be added to charts on a regular worksheet, but it isn’t a common
practice because the worksheet itself already displays the data.


2ON THE CHART TOOLS LAYOUT TAB, CLICK THE DATA TABLE BUTTON IN THE LABELS GROUP.

Options include None (to remove a data table), Show Data Table, and Show Data
Table with Legend Keys.






3MAKE A SELECTION FROM THE DATA TABLE MENU.

You can select More Data Table Options to see additional formatting options for
data tables.


4CLICK OK.

A data table showing the actual values appears at the bottom of the chart.

AddThis Sharing Buttons
Share to FacebookFacebookShare to TwitterTwitterShare to LinkedInLinkedInShare
to EmailEmail


ABOUT THE BOOK AUTHOR

Diane Koers owns and operates All Business Service, a software training and
consulting business formed in 1988, that services the central Indiana area. Her
area of expertise has long been in the word-processing, spreadsheet, and
graphics areas of computing. She also provides training and support for
Peachtree Accounting Software. Diane's authoring experience includes over 40
books on topics, such as PC security, Microsoft Windows, Microsoft Office,
Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken,
Microsoft Money, and Peachtree Accounting. Many of these titles have been
translated into other languages, such as French, Dutch, Bulgarian, Spanish, and
Greek. She has also developed and written numerous training manuals for her
clients.
Diane and her husband enjoy spending their free time fishing, traveling, and
playing with their four grandsons and their Yorkshire Terrier.



RELATED BOOK

Excel 2010 Just the Steps For Dummies




RELATED ARTICLES

 * 5 New Charts to Visually Display Data in Excel 2019
 * How to Add Infographics to an Excel 2019 Worksheet
 * Format Numbers in Thousands and Millions in Excel Reports





RELATED ARTICLES

 * 5 New Charts to Visually Display Data in Excel 2019
 * How to Add Infographics to an Excel 2019 Worksheet
 * Format Numbers in Thousands and Millions in Excel Reports




RELATED BOOK

Excel 2010 Just the Steps For Dummies



Close X
 * About For Dummies
 * Subscribe or Unsubscribe
 * Dummies Custom Solutions
 * Test Banks
 * Help

 * Privacy Policy
 * Terms and Conditions
 * Advertise with Us
 * Contact Us
 * Cookie Preferences

Dummies has always stood for taking on complex concepts and making them easy to
understand. Dummies helps everyone be more knowledgeable and confident in
applying what they know. Whether it’s to pass that big test, qualify for that
big promotion or even master that cooking technique; people who rely on dummies,
rely on it to learn the critical skills and relevant information necessary for
success.

dummies

Learning Made Easy

Copyright © 2021 & Trademark by John Wiley & Sons, Inc. All rights reserved.

 * 
 * 
 * 
 * 

   
   





NEWSLETTER SIGN UP

Would you like to join the Dummies newsletter so that you can be informed of new
content, promotions and the latest on books and authors?

You have entered an invalid email. Please re-enter it.


 * XS

 * SM

 * MD

 * LG