{"id":716,"date":"2023-06-15T21:06:44","date_gmt":"2023-06-15T21:06:44","guid":{"rendered":"https:\/\/www.offidocs.com\/blog\/?p=716"},"modified":"2023-06-15T21:06:45","modified_gmt":"2023-06-15T21:06:45","slug":"sankey-chart-excel","status":"publish","type":"post","link":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/","title":{"rendered":"Sankey Chart Excel &#8211; Everything You Need to Know"},"content":{"rendered":"\n<p>When it comes to visualizing complex flows, relationships, and transitions in data, the Sankey Chart excel in providing clear and concise representations. Sankey charts, also known as Sankey diagrams, offer a unique and effective way to showcase the distribution and movement of quantities over multiple categories or stages.<\/p>\n\n\n\n<p>Join us as we explore the concept of Sankey charts in Excel and their applications, and provide answers to frequently asked questions to help you leverage this powerful visualization tool.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Quick Answer<\/strong><\/td><\/tr><tr><td>A Sankey chart in Excel is a visual representation that showcases the flow of data, energy, or resources between different categories or stages. Sankey charts excel in presenting complex flows and relationships in a clear and concise manner, making them useful in various applications such as energy management, financial analysis, customer journeys, and process mapping.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Understanding Sankey Charts in Excel<\/strong><\/h1>\n\n\n\n<p><strong>Definition: The Sankey Chart depicts &#8220;a flow&#8221; of data from one set to the next. The two elements that are linked are referred to as &#8220;nodes.&#8221; The connections are denoted by the term &#8220;links.&#8221; <\/strong>Moreover, it is named after an Irishman, Capt. Matthew Sankey, who used them for the first time in a study on the energy efficiency of a steam engine in 1898.<\/p>\n\n\n\n<p>Sankey charts in Excel are visual representations that showcase the flow of data, energy, resources, or any other quantity between different categories or stages. These charts use connected flow lines or ribbons to depict the proportionate quantities or values moving from one category to another.&nbsp;<\/p>\n\n\n\n<p>The width of the lines or ribbons represents the magnitude of the flow, providing an intuitive and visually appealing display of the data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Components of a Sankey Chart in Excel<\/strong><\/h3>\n\n\n\n<p>A Sankey diagram is a simple diagram that consists of the following elements:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nodes: An element connected by &#8220;Flows.&#8221; It also represents the occurrences in each path.<\/li>\n\n\n\n<li>Flow: Flows connect the nodes. And the names of the source and target nodes in the &#8220;from&#8221; and &#8220;to&#8221; fields are used to identify each flow. Furthermore, the width field value defines the flow&#8217;s thickness.<\/li>\n\n\n\n<li>Drop-offs: A drop-off is a flow that does not have a target node.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Applications of Sankey Charts in Excel<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-1024x576.jpg\" alt=\"Chart Excel \" class=\"wp-image-728\" srcset=\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-1024x576.jpg 1024w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-300x169.jpg 300w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-768x432.jpg 768w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-1536x864.jpg 1536w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/124-1-2048x1152.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Sankey Chart Excel <\/figcaption><\/figure>\n<\/div>\n\n\n<p>Sankey charts find extensive use in various domains due to their ability to represent complex relationships and flows. Some common applications include:<\/p>\n\n\n\n<p><strong>a. Energy and Resource Management:<\/strong> Sankey charts can illustrate energy consumption, distribution, and losses in power systems, as well as the flow of resources in manufacturing processes.<\/p>\n\n\n\n<p><strong>b. Financial Analysis:<\/strong> Sankey charts can showcase cash flow, budget allocations, and investment portfolios, highlighting the movement of funds between different categories.<\/p>\n\n\n\n<p><strong>c. Customer Journeys:<\/strong> Sankey charts can demonstrate <a href=\"https:\/\/www.questionpro.com\/blog\/consumer-behavior-definition\/#:~:text=consumer%20behavior%20research%3F-,What%20is%20consumer%20behavior%3F,consumers%20engage%20with%20the%20market.\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">customer behavior<\/a>, showing the progression of individuals through different stages such as website visits, conversions, and purchases.<\/p>\n\n\n\n<p><strong>d. Process Mapping:<\/strong> Sankey charts can visualize process flows, displaying the movement of inputs, outputs, and transformations in manufacturing, logistics, or project management.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How to Create Sankey Diagram in Excel<\/strong><\/h3>\n\n\n\n<p>Excel provides several options for creating Sankey charts, including built-in templates and add-ins. Here are the general steps to create a Sankey chart in Excel:<\/p>\n\n\n\n<p><strong>a. Organize your data:<\/strong> Prepare a dataset with columns representing source, target, and flow values. Each row corresponds to a flow between two categories.<\/p>\n\n\n\n<p><strong>b. Insert a Sankey chart:<\/strong> Select the data range, go to the Insert tab, and choose the Sankey chart option. Excel will generate a basic Sankey chart based on your data.<\/p>\n\n\n\n<p><strong>c. Customize the chart:<\/strong> Format the chart by adjusting colors, line thickness, labels, and other visual elements to enhance clarity and aesthetics. Use Excel&#8217;s chart tools to modify the chart as per your requirements.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Energy Management Application<\/h3>\n\n\n\n<p>Assume you&#8217;ve been asked by a fictional country&#8217;s Energy Commission with analyzing their massive data. They wish to know the following information on domestic energy consumption:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Each energy-generating source&#8217;s contribution.<\/li>\n\n\n\n<li>The total quantity of energy lost.<\/li>\n\n\n\n<li>The contribution of cleaner and greener energy sources.<\/li>\n\n\n\n<li>Energy usage patterns by consumer segment (commercial use versus domestic use).<\/li>\n<\/ul>\n\n\n\n<p>The Energy Commission is looking for a data story to use in the upcoming announcement of its 10-year plan. The example data for the scenario above is shown in the table below.<\/p>\n\n\n\n<p><strong>Note:<\/strong> The table below is quite long to demonstrate how Sankey can present massive data sets without concealing key information.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Data Table<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>Energy Type<\/strong><\/th><th><strong>Main Source<\/strong><\/th><th><strong>Source type<\/strong><\/th><th><strong>Energy Source<\/strong><\/th><th><strong>Usage<\/strong><\/th><th><strong>End-User<\/strong><\/th><th><strong>MegaWatt<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>5<\/td><\/tr><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>7.3<\/td><\/tr><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>5.1<\/td><\/tr><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>3.7<\/td><\/tr><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>4.9<\/td><\/tr><tr><td>Agricultural waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>2<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>7.2<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>5.4<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>6.7<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>4.8<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>7.4<\/td><\/tr><tr><td>Other waste<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>2.5<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>0.7<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>0.5<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>0.9<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>0.5<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>0.8<\/td><\/tr><tr><td>Marina algae<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>0.6<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>1.3<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>2.5<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>3.2<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>0.7<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>1.4<\/td><\/tr><tr><td>Land-based bioenergy<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>0.9<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>0.4<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>0.7<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>0.8<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>0.3<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>0.6<\/td><\/tr><tr><td>Biomass import<\/td><td>Bio-conversion<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>0.2<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>50<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>13<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>8<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>6<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>11<\/td><\/tr><tr><td>Nuclear reserves<\/td><td>Nuclear Plant<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>4<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>4.7<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>3.1<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>4.2<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>0.7<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 commercial<\/td><td>4.8<\/td><\/tr><tr><td>Coal reserves<\/td><td>Coal<\/td><td>Solid<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Lighting &amp; appliances \u2013 homes<\/td><td>0.5<\/td><\/tr><tr><td>Gas reserves<\/td><td>Natural Gas<\/td><td>Gas<\/td><td>Thermal generation<\/td><td>Losses in process<\/td><td>Lost<\/td><td>5.1<\/td><\/tr><tr><td>Gas reserves<\/td><td>Natural Gas<\/td><td>Gas<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Industry<\/td><td>8.4<\/td><\/tr><tr><td>Gas reserves<\/td><td>Natural Gas<\/td><td>Gas<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 commercial<\/td><td>7.9<\/td><\/tr><tr><td>Gas reserves<\/td><td>Natural Gas<\/td><td>Gas<\/td><td>Thermal generation<\/td><td>Electricity grid<\/td><td>Heating and cooling \u2013 homes<\/td><td>4.8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Steps to Visualize Data with Sankey Charts<\/h4>\n\n\n\n<p>Now let\u2019s use ChartExpo Add-in for this data.<\/p>\n\n\n\n<p>To visualize your data with Sankey Charts, simply follow the instructions outlined below.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on Add-ins &gt; ChartExpo &gt; Insert<\/li>\n\n\n\n<li>Click on Sankey Chart.<\/li>\n\n\n\n<li>Choose the variables: Type, Main Source, Source type, Energy Source, Usage, End User, Mega Watt.<\/li>\n\n\n\n<li>Select Create Chart from Sheet Data. Now you should get a result on your screen.<\/li>\n<\/ul>\n\n\n\n<p><strong><em>Note: <\/em><\/strong><em>You have the option of editing the chart to highlight important information. Simply click the Edit Chart button.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Why You Should Use Sankey<\/strong><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-1024x576.jpg\" alt=\"Sankey Excel \" class=\"wp-image-725\" srcset=\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-1024x576.jpg 1024w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-300x169.jpg 300w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-768x432.jpg 768w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-1536x864.jpg 1536w, https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/122-2048x1152.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Sankey Chart Excel <\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Sankey Charts for Excel spreadsheet allows you to visually depict complex processes while focusing on a specific component or resource that you want to highlight.<\/li>\n\n\n\n<li>Sankey also has the advantage of supporting numerous viewing levels.<\/li>\n<\/ol>\n\n\n\n<p>Aside from that, viewers can acquire a high-level overview, view individual information, or build interactive views.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>These visualization charts highlight dominant contributors or consumers. As a result, your audience will be able to notice crucial insights such as relative magnitudes and regions with the greatest prospects.<\/li>\n<\/ol>\n\n\n\n<p>Assume you have data from various but interconnected segments. You&#8217;ve discovered a point of leaking. And you want to bring this to your company&#8217;s management&#8217;s attention. How would you approach it?&nbsp;<\/p>\n\n\n\n<p>You were completely correct. A data story is a great tool for convincing management to act on your recommendations. But how would you make this story compelling?<\/p>\n\n\n\n<p>You must utilize clear and easy-to-understand graphics. You don&#8217;t want your viewers to become disoriented while attempting to decipher insights from a chart. This is a morale destroyer. A Sankey is strategically placed to show the data scenario described above. This is due to the fact that it might help construct a realistic picture of the leakage in the minds of the audience (in our case, company management). Yes, you read that correctly.<\/p>\n\n\n\n<p>This chart will reveal the precise locations of the leakage. As previously stated, leakages, also known as drop-off zones, are flows that do not have a target node. Choosing relevant and simple charts makes it simple for your audience to grasp and interact with the data.<\/p>\n\n\n\n<p><strong>READ ALSO:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.offidocs.com\/blog\/how-to-print-gridlines-in-excel-online\/\">How to Print Gridlines in Excel Online<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.offidocs.com\/blog\/how-to-import-data-into-excel-online\/\">How to Import Data into Excel Online<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.offidocs.com\/blog\/how-to-get-excel-certified-online\/\">How to get Excel Certified Online<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.offidocs.com\/blog\/how-to-access-excel-online\/\">How to Access Excel Online<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Frequently Asked Questions<\/h3>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1686733230851\"><strong class=\"schema-faq-question\"><strong>Can I Create a Sankey Chart in Older Versions of Excel?<\/strong><\/strong> <p class=\"schema-faq-answer\">Sankey charts are not natively available in older versions of Excel. However, you can explore third-party add-ins or consider upgrading to newer versions that support Sankey chart creation.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1686733255395\"><strong class=\"schema-faq-question\"><strong>How do I handle large datasets in Sankey charts?<\/strong><\/strong> <p class=\"schema-faq-answer\">Sankey charts can handle large datasets, but it&#8217;s crucial to ensure data accuracy and avoid clutter. Consider aggregating or summarizing data if there are too many categories or flows to maintain chart readability.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1686733267633\"><strong class=\"schema-faq-question\"><strong>Can I export a Sankey Chart from Excel to other applications?<\/strong><\/strong> <p class=\"schema-faq-answer\">Yes, you can export Sankey charts from Excel to other applications as image files or copy and paste them into documents, presentations, or graphic design software.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1686733281465\"><strong class=\"schema-faq-question\"><strong>Are there any limitations to Creating Sankey charts in Excel?<\/strong><\/strong> <p class=\"schema-faq-answer\">While Excel provides basic functionality to create Sankey charts, it has certain limitations compared to dedicated <a href=\"https:\/\/builtin.com\/data-science\/data-visualization-tools\" target=\"_blank\" rel=\"noreferrer noopener\">data visualization tools<\/a>. Some limitations include the lack of advanced customization options, limited interactivity, and difficulties in handling large or complex datasets.<br\/><br\/>Consider using specialized data visualization software or add-ins if you require more advanced features and flexibility.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1686733313760\"><strong class=\"schema-faq-question\"><strong>Can I add Additional Data to a Sankey Chart in Excel?<\/strong><\/strong> <p class=\"schema-faq-answer\"><br\/>Yes, you can add supplementary data to a Sankey chart in Excel. This can be achieved by adding additional columns to your data table and mapping them to specific visual elements within the chart. For example, you could include tooltips, labels, or additional flow values to provide more context to the chart.<\/p> <\/div> <\/div>\n\n\n\n<h3 class=\"wp-block-heading\">The Wrap-Up<\/h3>\n\n\n\n<p>Sankey Charts for Excel are among the best charts you can use to make your data narrative irresistible to your audiences. This chart is incredibly easy to read and interpret, and you can rely on it to highlight the key insights supporting the thesis statement of your data story. You can draw this chart with very simple steps using Excel&#8217;s ChartExpo library.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When it comes to visualizing complex flows, relationships, and transitions in data, the Sankey Chart excel in providing clear and concise representations. Sankey charts, also<\/p>\n","protected":false},"author":1,"featured_media":726,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[28,68],"class_list":["post-716","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-online-editors","tag-free-excel-xls","tag-sankey-chart"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sankey Chart Excel - Everything You Need to Know<\/title>\n<meta name=\"description\" content=\"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sankey Chart Excel - Everything You Need to Know\" \/>\n<meta property=\"og:description\" content=\"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"OffiDocs\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-15T21:06:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T21:06:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2240\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/\",\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/\",\"name\":\"Sankey Chart Excel - Everything You Need to Know\",\"isPartOf\":{\"@id\":\"https:\/\/www.offidocs.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg\",\"datePublished\":\"2023-06-15T21:06:44+00:00\",\"dateModified\":\"2023-06-15T21:06:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/b4df979c363c4cea68464ea87edf90e3\"},\"description\":\"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851\"},{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395\"},{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633\"},{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465\"},{\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage\",\"url\":\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg\",\"contentUrl\":\"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg\",\"width\":2240,\"height\":1260,\"caption\":\"Sankey Chart Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.offidocs.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sankey Chart Excel &#8211; Everything You Need to Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/#website\",\"url\":\"https:\/\/www.offidocs.com\/blog\/\",\"name\":\"OffiDocs\",\"description\":\"Free Cloud Apps with OffiDocs\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.offidocs.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/b4df979c363c4cea68464ea87edf90e3\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f9a06652c90b56b2c5461dbd9975181f6a182d725ca6b2880c0ee4e82e3f88b1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f9a06652c90b56b2c5461dbd9975181f6a182d725ca6b2880c0ee4e82e3f88b1?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/136.243.69.186:19180\/blog\"]},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851\",\"position\":1,\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851\",\"name\":\"Can I Create a Sankey Chart in Older Versions of Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Sankey charts are not natively available in older versions of Excel. However, you can explore third-party add-ins or consider upgrading to newer versions that support Sankey chart creation.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395\",\"position\":2,\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395\",\"name\":\"How do I handle large datasets in Sankey charts?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Sankey charts can handle large datasets, but it's crucial to ensure data accuracy and avoid clutter. Consider aggregating or summarizing data if there are too many categories or flows to maintain chart readability.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633\",\"position\":3,\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633\",\"name\":\"Can I export a Sankey Chart from Excel to other applications?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes, you can export Sankey charts from Excel to other applications as image files or copy and paste them into documents, presentations, or graphic design software.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465\",\"position\":4,\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465\",\"name\":\"Are there any limitations to Creating Sankey charts in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"While Excel provides basic functionality to create Sankey charts, it has certain limitations compared to dedicated <a href=\\\"https:\/\/builtin.com\/data-science\/data-visualization-tools\\\" target=\\\"_blank\\\" rel=\\\"noreferrer noopener\\\">data visualization tools<\/a>. Some limitations include the lack of advanced customization options, limited interactivity, and difficulties in handling large or complex datasets.<br \/><br \/>Consider using specialized data visualization software or add-ins if you require more advanced features and flexibility.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760\",\"position\":5,\"url\":\"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760\",\"name\":\"Can I add Additional Data to a Sankey Chart in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<br \/>Yes, you can add supplementary data to a Sankey chart in Excel. This can be achieved by adding additional columns to your data table and mapping them to specific visual elements within the chart. For example, you could include tooltips, labels, or additional flow values to provide more context to the chart.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sankey Chart Excel - Everything You Need to Know","description":"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...","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:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/","og_locale":"en_US","og_type":"article","og_title":"Sankey Chart Excel - Everything You Need to Know","og_description":"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...","og_url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/","og_site_name":"OffiDocs","article_published_time":"2023-06-15T21:06:44+00:00","article_modified_time":"2023-06-15T21:06:45+00:00","og_image":[{"width":2240,"height":1260,"url":"http:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/","url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/","name":"Sankey Chart Excel - Everything You Need to Know","isPartOf":{"@id":"https:\/\/www.offidocs.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg","datePublished":"2023-06-15T21:06:44+00:00","dateModified":"2023-06-15T21:06:45+00:00","author":{"@id":"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/b4df979c363c4cea68464ea87edf90e3"},"description":"When it comes to visualizing complex flows, relationships, and transitions in data, Sankey charts excel in providing clear and conc...","breadcrumb":{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851"},{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395"},{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633"},{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465"},{"@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#primaryimage","url":"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg","contentUrl":"https:\/\/www.offidocs.com\/blog\/wp-content\/uploads\/2023\/06\/123.jpg","width":2240,"height":1260,"caption":"Sankey Chart Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.offidocs.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Sankey Chart Excel &#8211; Everything You Need to Know"}]},{"@type":"WebSite","@id":"https:\/\/www.offidocs.com\/blog\/#website","url":"https:\/\/www.offidocs.com\/blog\/","name":"OffiDocs","description":"Free Cloud Apps with OffiDocs","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.offidocs.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/b4df979c363c4cea68464ea87edf90e3","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.offidocs.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f9a06652c90b56b2c5461dbd9975181f6a182d725ca6b2880c0ee4e82e3f88b1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f9a06652c90b56b2c5461dbd9975181f6a182d725ca6b2880c0ee4e82e3f88b1?s=96&d=mm&r=g","caption":"admin"},"sameAs":["http:\/\/136.243.69.186:19180\/blog"]},{"@type":"Question","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851","position":1,"url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733230851","name":"Can I Create a Sankey Chart in Older Versions of Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Sankey charts are not natively available in older versions of Excel. However, you can explore third-party add-ins or consider upgrading to newer versions that support Sankey chart creation.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395","position":2,"url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733255395","name":"How do I handle large datasets in Sankey charts?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Sankey charts can handle large datasets, but it's crucial to ensure data accuracy and avoid clutter. Consider aggregating or summarizing data if there are too many categories or flows to maintain chart readability.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633","position":3,"url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733267633","name":"Can I export a Sankey Chart from Excel to other applications?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes, you can export Sankey charts from Excel to other applications as image files or copy and paste them into documents, presentations, or graphic design software.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465","position":4,"url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733281465","name":"Are there any limitations to Creating Sankey charts in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"While Excel provides basic functionality to create Sankey charts, it has certain limitations compared to dedicated <a href=\"https:\/\/builtin.com\/data-science\/data-visualization-tools\" target=\"_blank\" rel=\"noreferrer noopener\">data visualization tools<\/a>. Some limitations include the lack of advanced customization options, limited interactivity, and difficulties in handling large or complex datasets.<br \/><br \/>Consider using specialized data visualization software or add-ins if you require more advanced features and flexibility.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760","position":5,"url":"https:\/\/www.offidocs.com\/blog\/sankey-chart-excel\/#faq-question-1686733313760","name":"Can I add Additional Data to a Sankey Chart in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<br \/>Yes, you can add supplementary data to a Sankey chart in Excel. This can be achieved by adding additional columns to your data table and mapping them to specific visual elements within the chart. For example, you could include tooltips, labels, or additional flow values to provide more context to the chart.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/comments?post=716"}],"version-history":[{"count":4,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":730,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/posts\/716\/revisions\/730"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/media\/726"}],"wp:attachment":[{"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/media?parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/categories?post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.offidocs.com\/blog\/wp-json\/wp\/v2\/tags?post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}