{"id":9145,"date":"2019-10-11T06:30:32","date_gmt":"2019-10-11T04:30:32","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9145"},"modified":"2019-10-11T06:30:34","modified_gmt":"2019-10-11T04:30:34","slug":"how-to-present-lines-on-two-axes-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-excel-2007\/","title":{"rendered":"How to present lines on two axes? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Prepare your\ngraph using the line chart. On the chart right click on the data series that\nyou wish to present on another axis on the right and choose &#8220;Format Data\nSeries&#8221; from the menu. From the appearing new window make sure you&#8217;re on\n&#8220;Series Options&#8221; and choose the option &#8220;Secondary Axis&#8221;.\nClick on &#8220;OK&#8221;, when you&#8217;re done.<\/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 present lines on two axes? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/AqlpI0qL8ZU?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>Prepare your graph using the line chart. On the chart right click on the data series that you wish to present on another axis on the right and choose &#8220;Format Data Series&#8221; from the menu. From the appearing new window make sure you&#8217;re on &#8220;Series Options&#8221; and choose the option &#8220;Secondary Axis&#8221;. Click on &#8220;OK&#8221;, [&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":[3687,3509,3686],"class_list":["post-9145","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-axes","tag-excel-2007","tag-two"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Prepare your graph using the line chart. On the chart right click on the data series that you wish to present on another axis on the right and choose &quot;Format Data Series&quot; from the menu. From the appearing new window make sure you&#039;re on &quot;Series Options&quot; and choose the option &quot;Secondary Axis&quot;. Click on &quot;OK&quot;,\" \/>\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-present-lines-on-two-axes-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-present-lines-on-two-axes-excel-2007\\\/#article\",\"name\":\"How to present lines on two axes? | Excel 2007 | Office ToDo\",\"headline\":\"How to present lines on two axes? | Excel 2007\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-10-11T06:30:32+02:00\",\"dateModified\":\"2019-10-11T06:30:34+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-present-lines-on-two-axes-excel-2007\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-present-lines-on-two-axes-excel-2007\\\/#webpage\"},\"articleSection\":\"Excel 2007, axes, excel 2007, two\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-present-lines-on-two-axes-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-present-lines-on-two-axes-excel-2007\\\/#listItem\",\"name\":\"How to present lines on two axes? | 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-present-lines-on-two-axes-excel-2007\\\/#listItem\",\"position\":4,\"name\":\"How to present lines on two axes? | 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-present-lines-on-two-axes-excel-2007\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-present-lines-on-two-axes-excel-2007\\\/\",\"name\":\"How to present lines on two axes? | Excel 2007 | Office ToDo\",\"description\":\"Prepare your graph using the line chart. On the chart right click on the data series that you wish to present on another axis on the right and choose \\\"Format Data Series\\\" from the menu. From the appearing new window make sure you're on \\\"Series Options\\\" and choose the option \\\"Secondary Axis\\\". Click on \\\"OK\\\",\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-present-lines-on-two-axes-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-11T06:30:32+02:00\",\"dateModified\":\"2019-10-11T06:30:34+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 present lines on two axes? | Excel 2007 | Office ToDo","description":"Prepare your graph using the line chart. On the chart right click on the data series that you wish to present on another axis on the right and choose \"Format Data Series\" from the menu. From the appearing new window make sure you're on \"Series Options\" and choose the option \"Secondary Axis\". Click on \"OK\",","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-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-present-lines-on-two-axes-excel-2007\/#article","name":"How to present lines on two axes? | Excel 2007 | Office ToDo","headline":"How to present lines on two axes? | Excel 2007","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-10-11T06:30:32+02:00","dateModified":"2019-10-11T06:30:34+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-excel-2007\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-excel-2007\/#webpage"},"articleSection":"Excel 2007, axes, excel 2007, two"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-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-present-lines-on-two-axes-excel-2007\/#listItem","name":"How to present lines on two axes? | 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-present-lines-on-two-axes-excel-2007\/#listItem","position":4,"name":"How to present lines on two axes? | 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-present-lines-on-two-axes-excel-2007\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-excel-2007\/","name":"How to present lines on two axes? | Excel 2007 | Office ToDo","description":"Prepare your graph using the line chart. On the chart right click on the data series that you wish to present on another axis on the right and choose \"Format Data Series\" from the menu. From the appearing new window make sure you're on \"Series Options\" and choose the option \"Secondary Axis\". Click on \"OK\",","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-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-11T06:30:32+02:00","dateModified":"2019-10-11T06:30:34+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":"9145","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:03","updated":"2026-05-26 23:51:49","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 present lines on two axes? | 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 present lines on two axes? | Excel 2007","link":"http:\/\/www.officetodo.com\/public\/how-to-present-lines-on-two-axes-excel-2007\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9145","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=9145"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9145\/revisions"}],"predecessor-version":[{"id":9146,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9145\/revisions\/9146"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9145"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}