{"id":8961,"date":"2019-08-28T06:29:36","date_gmt":"2019-08-28T04:29:36","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=8961"},"modified":"2019-08-28T06:29:38","modified_gmt":"2019-08-28T04:29:38","slug":"how-to-add-a-data-table-to-a-chart-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/","title":{"rendered":"How to add a data table to a chart? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\n\nClick on the chart and go under Chart Tools and Layout tab. In Labels section click on &#8220;Data Table&#8221; and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in case you wish to remove the legend from the chart.\n\n<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to add a data table to a chart? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/XWjEqeUl-bc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Click on the chart and go under Chart Tools and Layout tab. In Labels section click on &#8220;Data Table&#8221; and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3501],"tags":[3536,3572,3509],"class_list":["post-8961","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-chart","tag-data","tag-excel-2007"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Click on the chart and go under Chart Tools and Layout tab. In Labels section click on &quot;Data Table&quot; and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Karl\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#article\",\"name\":\"How to add a data table to a chart? | Excel 2007 | Office ToDo\",\"headline\":\"How to add a data table to a chart? | Excel 2007\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-08-28T06:29:36+02:00\",\"dateModified\":\"2019-08-28T06:29:38+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#webpage\"},\"articleSection\":\"Excel 2007, chart, data, excel 2007\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"position\":2,\"name\":\"MS Office\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"position\":3,\"name\":\"Excel 2007\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#listItem\",\"name\":\"How to add a data table to a chart? | Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#listItem\",\"position\":4,\"name\":\"How to add a data table to a chart? | Excel 2007\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\",\"name\":\"Office ToDo\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/\",\"name\":\"Karl\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/\",\"name\":\"How to add a data table to a chart? | Excel 2007 | Office ToDo\",\"description\":\"Click on the chart and go under Chart Tools and Layout tab. In Labels section click on \\\"Data Table\\\" and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-add-a-data-table-to-a-chart-excel-2007\\\/#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2019-08-28T06:29:36+02:00\",\"dateModified\":\"2019-08-28T06:29:38+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\",\"name\":\"Office ToDo\",\"inLanguage\":\"en\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to add a data table to a chart? | Excel 2007 | Office ToDo","description":"Click on the chart and go under Chart Tools and Layout tab. In Labels section click on \"Data Table\" and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#article","name":"How to add a data table to a chart? | Excel 2007 | Office ToDo","headline":"How to add a data table to a chart? | Excel 2007","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-08-28T06:29:36+02:00","dateModified":"2019-08-28T06:29:38+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#webpage"},"articleSection":"Excel 2007, chart, data, excel 2007"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","position":1,"name":"Home","item":"http:\/\/www.officetodo.com\/public","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","position":2,"name":"MS Office","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","position":3,"name":"Excel 2007","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#listItem","name":"How to add a data table to a chart? | Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#listItem","position":4,"name":"How to add a data table to a chart? | Excel 2007","previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"}}]},{"@type":"Organization","@id":"http:\/\/www.officetodo.com\/public\/#organization","name":"Office ToDo","url":"http:\/\/www.officetodo.com\/public\/"},{"@type":"Person","@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author","url":"http:\/\/www.officetodo.com\/public\/author\/admin\/","name":"Karl"},{"@type":"WebPage","@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/","name":"How to add a data table to a chart? | Excel 2007 | Office ToDo","description":"Click on the chart and go under Chart Tools and Layout tab. In Labels section click on \"Data Table\" and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/#breadcrumblist"},"author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"creator":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"datePublished":"2019-08-28T06:29:36+02:00","dateModified":"2019-08-28T06:29:38+02:00"},{"@type":"WebSite","@id":"http:\/\/www.officetodo.com\/public\/#website","url":"http:\/\/www.officetodo.com\/public\/","name":"Office ToDo","inLanguage":"en","publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"}}]}},"aioseo_meta_data":{"post_id":"8961","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-05 05:13:27","updated":"2026-05-26 23:30:15","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/\" title=\"MS Office\">MS Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/\" title=\"Excel 2007\">Excel 2007<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to add a data table to a chart? | Excel 2007\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.officetodo.com\/public"},{"label":"MS Office","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/"},{"label":"Excel 2007","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/"},{"label":"How to add a data table to a chart? | Excel 2007","link":"http:\/\/www.officetodo.com\/public\/how-to-add-a-data-table-to-a-chart-excel-2007\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=8961"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8961\/revisions"}],"predecessor-version":[{"id":8962,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8961\/revisions\/8962"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=8961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=8961"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=8961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}