{"id":9203,"date":"2019-10-16T06:44:22","date_gmt":"2019-10-16T04:44:22","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9203"},"modified":"2019-10-16T06:44:24","modified_gmt":"2019-10-16T04:44:24","slug":"how-to-compare-values-across-categories-on-a-chart-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-a-chart-excel-2007\/","title":{"rendered":"How to compare values across categories on a chart? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Best used\nfor such a comparison is the chart with columns. Select your table only\nincluding the cells you wish to be presented on the chart and go under Insert\ntab into Charts section. Under &#8220;Column&#8221; choose the type of the column\nchart that suits you best. Unfortunately no live preview is applicable in this\ncase.&nbsp; <\/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 compare values across categories on a chart? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/um1jDYZwFHQ?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>Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under &#8220;Column&#8221; choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this [&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":[3550,3509,3720],"class_list":["post-9203","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-compare","tag-excel-2007","tag-value"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under &quot;Column&quot; choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this\" \/>\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-compare-values-across-categories-on-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-compare-values-across-categories-on-a-chart-excel-2007\\\/#article\",\"name\":\"How to compare values across categories on a chart? | Excel 2007 | Office ToDo\",\"headline\":\"How to compare values across categories on a chart? | Excel 2007\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-10-16T06:44:22+02:00\",\"dateModified\":\"2019-10-16T06:44:24+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-compare-values-across-categories-on-a-chart-excel-2007\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-compare-values-across-categories-on-a-chart-excel-2007\\\/#webpage\"},\"articleSection\":\"Excel 2007, compare, excel 2007, value\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-compare-values-across-categories-on-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-compare-values-across-categories-on-a-chart-excel-2007\\\/#listItem\",\"name\":\"How to compare values across categories on 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-compare-values-across-categories-on-a-chart-excel-2007\\\/#listItem\",\"position\":4,\"name\":\"How to compare values across categories on 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-compare-values-across-categories-on-a-chart-excel-2007\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-compare-values-across-categories-on-a-chart-excel-2007\\\/\",\"name\":\"How to compare values across categories on a chart? | Excel 2007 | Office ToDo\",\"description\":\"Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under \\\"Column\\\" choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-compare-values-across-categories-on-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-10-16T06:44:22+02:00\",\"dateModified\":\"2019-10-16T06:44:24+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 compare values across categories on a chart? | Excel 2007 | Office ToDo","description":"Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under \"Column\" choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-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-compare-values-across-categories-on-a-chart-excel-2007\/#article","name":"How to compare values across categories on a chart? | Excel 2007 | Office ToDo","headline":"How to compare values across categories on a chart? | Excel 2007","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-10-16T06:44:22+02:00","dateModified":"2019-10-16T06:44:24+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-a-chart-excel-2007\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-a-chart-excel-2007\/#webpage"},"articleSection":"Excel 2007, compare, excel 2007, value"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-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-compare-values-across-categories-on-a-chart-excel-2007\/#listItem","name":"How to compare values across categories on 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-compare-values-across-categories-on-a-chart-excel-2007\/#listItem","position":4,"name":"How to compare values across categories on 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-compare-values-across-categories-on-a-chart-excel-2007\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-a-chart-excel-2007\/","name":"How to compare values across categories on a chart? | Excel 2007 | Office ToDo","description":"Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under \"Column\" choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-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-10-16T06:44:22+02:00","dateModified":"2019-10-16T06:44:24+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":"9203","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:09:02","updated":"2026-05-26 23:58:10","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 compare values across categories on 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 compare values across categories on a chart? | Excel 2007","link":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-across-categories-on-a-chart-excel-2007\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9203","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=9203"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9203\/revisions"}],"predecessor-version":[{"id":9204,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9203\/revisions\/9204"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9203"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}