{"id":16133,"date":"2023-08-01T12:37:16","date_gmt":"2023-08-01T12:37:16","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16133"},"modified":"2024-03-26T11:48:37","modified_gmt":"2024-03-26T11:48:37","slug":"creating-a-hyperlink-to-a-chart","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/","title":{"rendered":"Creating a Hyperlink to a Chart"},"content":{"rendered":"\n
Creating-a-Hyperlink-to-a-Chart<\/a>Download File<\/a><\/div>\n\n\n\n

Excel is a great tool for manipulating data, and we can do that with formulas, tables, charts, and so many other options.<\/p>\n\n\n\n

We can combine all of the options to achieve full results. In the example below, we will show how to create a hyperlink to a chart<\/strong>.<\/p>\n\n\n\n

Create a Hyperlink to a Chart<\/h2>\n\n\n\n

We will create our chart from the data about the NBA players and several statistical categories<\/strong>: points, rebounds, assists, and turnovers:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To create a chart, we will select the data in columns A and D<\/strong>, then go to Insert >> Recommended Charts<\/strong>, and then choose any of the recommended charts (chart type is not relevant in this example).:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will choose Clustered Column<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will have the same chart created. Now, in order to create a hyperlink to this chart, we first need to select the chart. We will know it is selected when the resizing handles can be seen around the chart:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For the next thing, we need to copy the chart to the clipboard. We do that by right-clicking on the chart and selecting Copy<\/strong>, or we use one of the standard keyboard shortcuts (CTRL + C for Windows, or Command +C for Mac)<\/strong>.<\/p>\n\n\n\n

We will paste our Chart in a separate sheet (that we will name simply \u201cChart\u201d<\/strong>) by pressing CTRL + P<\/strong> in it:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will return to the original sheet, then create a text for Chart in cell A13<\/strong>, right-click on it, and then choose Link<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the window that appears, we will choose Place in This Document<\/strong> in the Link to section<\/strong>, and we will choose Chart in Cell Reference<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When we click OK<\/strong>, we will notice that the words in our cell are now blue and underlined<\/strong>, which is a default formatting for hyperlinked text<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When we click on the word Chart in cell A13<\/strong>, we will be immediately directed to our sheet Chart<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

As seen in the Insert Hyperlink window<\/strong>, there is an option for us to link the chart from 1) an existing file or web page, 2) place it in the document (which we did), 3) an e-mail address, or 4) we can create another document<\/strong>.<\/p>\n\n\n\n

It’s important to note that the steps we presented above may vary depending on the software we are using, but the general idea is the same. The chart that we are linking to needs to be accessible and doesn’t require additional permissions to view. If we were linking to an online chart, we would have to ensure that the URL is correct, and the link is working properly<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Excel is a great tool for manipulating data, and we can do that with formulas, tables, charts, and so many other options. We…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nCreating a Hyperlink to a Chart<\/title>\n<meta name=\"description\" content=\"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a Hyperlink to a Chart\" \/>\n<meta property=\"og:description\" content=\"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-01T12:37:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:48:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Creating a Hyperlink to a Chart\",\"datePublished\":\"2023-08-01T12:37:16+00:00\",\"dateModified\":\"2024-03-26T11:48:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\"},\"wordCount\":434,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\",\"name\":\"Creating a Hyperlink to a Chart\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png\",\"datePublished\":\"2023-08-01T12:37:16+00:00\",\"dateModified\":\"2024-03-26T11:48:37+00:00\",\"description\":\"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png\",\"width\":686,\"height\":274},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a Hyperlink to a Chart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a Hyperlink to a Chart","description":"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/","og_locale":"en_US","og_type":"article","og_title":"Creating a Hyperlink to a Chart","og_description":"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.","og_url":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/","article_published_time":"2023-08-01T12:37:16+00:00","article_modified_time":"2024-03-26T11:48:37+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Creating a Hyperlink to a Chart","datePublished":"2023-08-01T12:37:16+00:00","dateModified":"2024-03-26T11:48:37+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/"},"wordCount":434,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/","url":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/","name":"Creating a Hyperlink to a Chart","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png","datePublished":"2023-08-01T12:37:16+00:00","dateModified":"2024-03-26T11:48:37+00:00","description":"Excel tutorial on how to create a hyperlink to a chart using data about NBA players and statistical categories. Download the file here.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16133-1.png","width":686,"height":274},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/creating-a-hyperlink-to-a-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Creating a Hyperlink to a Chart"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16133"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=16133"}],"version-history":[{"count":1,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16133\/revisions"}],"predecessor-version":[{"id":16144,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16133\/revisions\/16144"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=16133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=16133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=16133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}