{"id":20950,"date":"2023-12-09T03:59:55","date_gmt":"2023-12-09T03:59:55","guid":{"rendered":"https:\/\/ppcexpo.com\/blog\/?p=20950"},"modified":"2025-06-26T20:59:25","modified_gmt":"2025-06-26T15:59:25","slug":"how-to-add-excel-add-ins","status":"publish","type":"post","link":"https:\/\/ppcexpo.com\/blog\/how-to-add-excel-add-ins","title":{"rendered":"How to Add, Use, and Remove Excel Add-ins?"},"content":{"rendered":"<p>It is observed that over 50% of Excel users don\u2019t use add-ins to save time or make their lives a little easier.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/12\/how-to-add-excel-add-ins.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytwYitwcGMrUFBDUEJJNjI0K1NhbmtleSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\" https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><\/div>\n<p>And we can\u2019t blame them. Because they might be scared of coding or any technical complications. Here, we will talk about ChartExpo Add-in which is very easy to configure to create amazing visualizations.<\/p>\n<p>Let\u2019s dive in.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#add-ins-in-excel-definition\">What are Add-ins in Excel?<\/a><\/li>\n<li><a href=\"#video-tutorial\">Video Tutorial: How to Install Add-ins in Excel<\/a><\/li>\n<li><a href=\"#add-ins-in-excel-types\">Types of Add-ins in Excel<\/a><\/li>\n<li><a href=\"#add-ins-in-excel-importance\">Importance of Excel Add-Ins for Data Analysis<\/a><\/li>\n<li><a href=\"#how-to-add-excel-add-ins-in-windows\">How to Add Excel Add-ins in Windows?<\/a><\/li>\n<li><a href=\"#how-to-add-excel-add-ins-in-mac\">How to Add Excel Add-ins on Mac?<\/a><\/li>\n<li><a href=\"#access-chartexpo-add-in-in-excel\">How to Access ChartExpo Add-in in Excel?<\/a><\/li>\n<li><a href=\"#why-chartexpo-is-favorite\">Why ChartExpo is a Favorite Add-in for 20,000+ Users?<\/a><\/li>\n<li><a href=\"#create-chart-using-add-in-in-excel\">How to Create a Chart Using Add-in in Excel?<\/a><\/li>\n<li><a href=\"#remove-add-ins-from-excel\">How to Remove Add-ins From Excel?<\/a><\/li>\n<li><a href=\"#add-excel-add-ins-faqs\">How to Add Excel Add-ins FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"add-ins-in-excel-definition\">What are Add-ins in Excel?<\/h2>\n<p><strong>Definition:<\/strong> Add-ins in Excel are specialized tools or extensions that enhance the software&#8217;s functionality by adding new features, commands, or capabilities.<\/p>\n<p>These can be built-in tools provided by Microsoft or third-party plugins that enable tasks such as advanced <a href=\"https:\/\/ppcexpo.com\/blog\/data-analysis-guide\" target=\"_blank\" rel=\"noopener\">data analysis<\/a>, chart creation, automation, and integration with other applications, making Excel more versatile for specific needs.<\/p>\n<h2 id=\"video-tutorial\">Video Tutorial: <span data-sheets-root=\"1\">How to Install Add-ins in Excel<\/span><\/h2>\n<div>\n<div style=\"text-align: center;\"><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/cWKBUrdIW88?si=xP6gXagPOlAIuyxj\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytwYitwcGMrUFBDUEJJNjI0K1NhbmtleSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\" https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><\/div>\n<\/div>\n<h2 id=\"add-ins-in-excel-types\">Types of Add-ins in Excel<\/h2>\n<p>There are several types of add-ins in Excel, catering to different functionalities and purposes. Here are some common types:<\/p>\n<ol>\n<li><strong>Excel Add-ins (COM Add-ins):<\/strong> These are custom programs or macros created using Visual Basic for Applications (VBA) that extend Excel&#8217;s functionality. Users can create and install these add-ins to automate tasks, create custom functions, or enhance data processing.<\/li>\n<li><strong>Analysis ToolPak:<\/strong> While not a traditional third-party add-in, Excel has an official add-in called Analysis ToolPak, which provides additional data analysis functions and statistical tools. Users can enable it to access a range of analytical capabilities.<\/li>\n<li><strong>Solver Add-in:<\/strong> Another official Excel add-in, Solver, is used for optimization and solving mathematical models. It allows users to find the best solution to a problem based on specified constraints and objectives.<\/li>\n<li><strong>Power Query Add-in:<\/strong> Integrated into Excel, Power Query is a data connection technology that allows users to discover, connect, and combine data across various sources. It&#8217;s especially useful for data transformation and cleaning tasks.<\/li>\n<li><strong>Power Pivot Add-in:<\/strong> Power Pivot is an add-in that enhances data modeling capabilities in Excel. It enables users to create more advanced data models, relationships, and calculations for in-depth analysis.<\/li>\n<li><strong>Power Map Add-in:<\/strong> Part of the Power BI suite, Power Map allows users to create 3D visualizations and interactive tours of geographical and temporal data. It provides a dynamic way to explore data on maps.<\/li>\n<li><strong>Third-Party Add-ins:<\/strong> Numerous third-party developers create Excel add-ins to address specific needs, such as financial analysis, project management, or industry-specific requirements. These add-ins can offer features like enhanced charts, reporting tools, and specialized functions.<\/li>\n<li><strong>Excel Web Add-ins:<\/strong> With the advent of cloud computing, Excel supports web add-ins that extend functionality through web technologies. These add-ins can be developed using HTML, JavaScript, and other web-based technologies, providing cross-platform compatibility.<\/li>\n<\/ol>\n<h2 id=\"add-ins-in-excel-importance\">Importance of Excel Add-Ins for Data Analysis<\/h2>\n<p>Excel Add-ins play a crucial role in enhancing data analysis by providing advanced tools and functionalities beyond Excel&#8217;s default features. They enable users to perform complex calculations, <a href=\"https:\/\/ppcexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener\">visualize data<\/a> more effectively, and automate repetitive tasks, saving time and effort.<\/p>\n<p>Add-ins like Power Query and Solver help streamline data cleaning, transformation, and optimization, while <a href=\"https:\/\/ppcexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener\">visualization tools<\/a> such as ChartExpo or Analysis ToolPak allow for creating dynamic charts and performing <a href=\"https:\/\/ppcexpo.com\/blog\/statistical-graphs\" target=\"_blank\" rel=\"noopener\">statistical analysis<\/a>.<\/p>\n<p>These add-ins expand Excel\u2019s capabilities, making it a powerful tool for comprehensive and efficient data analysis, suitable for businesses, researchers, and analysts.<\/p>\n<h2 id=\"how-to-add-excel-add-ins-in-windows\">How to Add Excel Add-ins in Windows?<\/h2>\n<p>Note: If you are using the Excel version of 2013 make sure to install Office Service Pack 1.<\/p>\n<p>There are two ways to configure ChartExpo Excel Add-in:<\/p>\n<h3>Directly from Microsoft App Store:<\/h3>\n<ul>\n<li>You can <a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjI3Kw==\" target=\"_blank\" rel=\"nofollow noopener\">click here to install<\/a> the ChartExpo add-in for your Excel application.<\/li>\n<li>The following page will appear in your browser, you can click on the \u201c<strong>Get it now\u201d<\/strong> button to proceed with the installation steps.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-1.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<ul>\n<li>Log in with your Microsoft account or create a new account.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-2.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Now you will see a window that will ask you to enter your credentials.<\/li>\n<li>After logging in, another ChartExpo window will appear. Here you can provide the required information and click on \u201cContinue\u201d button. It will automatically add ChartExpo dd-in in your Excel application.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-3.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Now you can click on the \u201cOpen in Excel\u201d button to continue using this Add-in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-4.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<h3>Install From Excel Application<\/h3>\n<ul>\n<li>To get started, open your Excel application.<\/li>\n<li>Open the worksheet and click on the \u201c<strong>Insert\u201d <\/strong><b>menu<\/b>.<\/li>\n<li>You\u2019ll see the \u201c<strong>My Apps\u201d <\/strong><b><\/b><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-05.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>In the office Add-ins window, click on \u201c<strong>Store\u201d <\/strong>and search for ChartExpo on my Apps Store.<\/li>\n<li>Click on the \u201cAdd\u201d button to install ChartExpo in your Excel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-6.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Once your ChartExpo is successfully installed now below you will learn how you can access and use it in Excel.<\/li>\n<\/ul>\n<h2 id=\"how-to-add-excel-add-ins-in-mac\">How to Add Excel Add-ins on Mac?<\/h2>\n<ol>\n<li><strong>Open Excel Add-ins Menu:<\/strong> Launch Excel on your Mac, click &#8220;Tools&#8221; in the top menu, and select &#8220;Excel Add-ins.&#8221;<\/li>\n<li><strong>Browse for Add-ins:<\/strong> In the pop-up window, you\u2019ll see a list of available add-ins. To add a new one, click &#8220;Browse&#8221; and locate the add-in file (usually with a .xlam or .xla extension).<\/li>\n<li><strong>Enable the Add-in:<\/strong> Check the box next to the add-in you want to enable and click &#8220;OK.&#8221; The add-in will now be accessible in your Excel toolbar.<\/li>\n<li><strong>Install from AppSource (Optional):<\/strong> For add-ins like ChartExpo, go to the <strong>Insert<\/strong> tab, click &#8220;Get Add-ins,&#8221; and search for it in Microsoft AppSource. Select and install it directly into Excel.<\/li>\n<\/ol>\n<h2 id=\"access-chartexpo-add-in-in-excel\">How to Access ChartExpo Add-in in Excel?<\/h2>\n<ul>\n<li>Click on the \u201c<strong>Insert\u201d <\/strong><b>menu<\/b> on the top toolbar.<\/li>\n<li>You\u2019ll see the <strong>My Apps option<\/strong> as highlighted below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-07.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Select ChartExpo for Excel and click on the \u201c<strong>Insert\u201d <\/strong><b><\/b><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-8.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>The add-in will be added to the Excel application, as shown below but it will ask you to log in to continue.<\/li>\n<li>You can log in with your Microsoft account or Google account or create a new account in ChartExpo and start using the add-in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-9.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>You\u2019re only required to <strong><em>log in for the first time<\/em><\/strong>. Next time, ChartExpo won\u2019t ask for log in again.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-10.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Once ChartExpo is loaded. By default, you will seea\u00a0 list view of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-11.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Click on Category and you can access 6 different categories of charts by clicking on Category.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-12.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<p>Voila! Your ChartExpo add-in is ready to use in your Excel application. You can explore all the charts available in this library and convert your data into amazing visualizations.<\/p>\n<h2 id=\"why-chartexpo-is-favorite\">Why ChartExpo is a Favorite Add-in for 20,000+ Users?<\/h2>\n<p>ChartExpo is an Excel add-in that\u2019s <strong>amazingly easy to use, <\/strong>especially when working with complex data.<\/p>\n<p>We recommend this app because it has a<em> free trial<\/em>, and most importantly, it has advanced charts. Yes, it comes <strong>loaded with charts you\u2019ll never see in your Excel<\/strong>, such as Sankey Diagrams, <a href=\"https:\/\/ppcexpo.com\/blog\/word-cloud\" target=\"_blank\" rel=\"noopener\">Word Cloud<\/a>, and Gauge Chart, among others.<\/p>\n<p>Its <strong>ultra-friendly user interface (UI)<\/strong> needs no video tutorial or a written manual to make its usage easier. And this means its <strong>learning curve is short<\/strong>. <em>Yes, you read that right.<\/em><\/p>\n<p>Look no further if you want to <em>boost your productivity<\/em> through the roof or <em>save hours whenever working with complex data<\/em>.<\/p>\n<p>The last time we checked, ChartExpo had over<strong> 50-plus advanced charts <\/strong>you can use to create\u00a0<span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">irresistible <a href=\"https:\/\/ppcexpo.com\/blog\/types-of-business-reports\" target=\"_blank\" rel=\"noopener\">business<\/a><\/span><a href=\"https:\/\/ppcexpo.com\/blog\/types-of-business-reports\" target=\"_blank\" rel=\"noopener\">\u00a0reports<\/a> and data stories.<\/p>\n<p><em>And it gets better!<\/em> This <strong>tool is incredibly light<\/strong>. So your <strong>Excel won\u2019t crash or slow down<\/strong>, even when working with large data sets.<\/p>\n<ol>\n<li><strong>It creates a visual appeal:<\/strong> As humans are notorious for having an ever-shrinking attention span, ChartExpo can go a long way in communicating your results which boil down to creating a visual appeal to the end-user. The reality is that clients not only want to interact with hard numbers but also need to visualize the success story behind the results. ChartExpo helps users combine elements of data, information, knowledge, and insights into a visual format that can be understandable by everyone.<\/li>\n<li><strong>Identify Trends Faster:<\/strong> The majority of human communication is visual as the human brain processes graphics magnitudes faster than it does text. Direct manipulation of analyzed data via ChartExpo makes it easy to understand and act on valuable information.<\/li>\n<li><strong>Identify Relationships More Effectively:<\/strong> ChartExpo enables users to identify otherwise overlooked cause-and-effect relationships throughout definable timeframes. This is especially useful in identifying how daily operations affect an organization\u2019s goals.<\/li>\n<li><strong>Useful Data Storytelling:<\/strong> Humans best understand a data story when its development over time is presented in a clear, linear fashion. ChartExpo helps users highlight relevant information, filter, and change the parameters to promote a better understanding of the data by presenting multiple viewpoints of the data.<\/li>\n<li><strong>Simplify Complex Data:<\/strong> A large data set with a complex data story may present itself visually as a chaotic, intertwined hairball. ChartExpo can help untangle and make these messes of data more manageable and can help users glean better insights.<\/li>\n<\/ol>\n<p>Faster and easier access to important business insights:<\/p>\n<p>ChartExpo can help businesses boost their ability to seek the information they need anytime, anywhere. And with the right solution, these businesses will be able to do so more efficiently than their competitors.<\/p>\n<p>Visualizing your data helps quickly identify any errors in the data. If the data tends to suggest the wrong actions, ChartExpo helps identify erroneous data when you try to visualize your data.<\/p>\n<p>Let\u2019s head to the <a href=\"https:\/\/ppcexpo.com\/blog\/data-storytelling\" target=\"_blank\" rel=\"noopener\">data storytelling<\/a> examples using our graph add-in for Excel: ChartExpo.<\/p>\n<h2 id=\"create-chart-using-add-in-in-excel\">How to Create a Chart Using Add-in in Excel?<\/h2>\n<p>There are many charts available in this library. We will pick the \u201cSankey Diagram\u201d to convert your data into an amazing visualization story.<\/p>\n<ul>\n<li>\n<h3>Sankey Diagram<\/h3>\n<\/li>\n<\/ul>\n<p>Sankey Diagrams (also known as <a href=\"https:\/\/ppcexpo.com\/blog\/energy-flow-diagram\" target=\"_blank\" rel=\"noopener noreferrer\">Energy Flow Diagrams<\/a>) are charts used to visualize data with flow-like attributes, such as energy flow, revenue flow, etc.<\/p>\n<p>In other words, these charts depict the flow from one set of values to another. The widths of its arrows are proportional to the flow rate.<\/p>\n<p>You can use this visualization to communicate sources and uses of the costs, materials, and resources represented.<\/p>\n<p><em>Let\u2019s take a look at an example with <a href=\"https:\/\/ppcexpo.com\/blog\/sankey-diagram\" target=\"_blank\" rel=\"noopener noreferrer\">Sankey Charts<\/a>.<\/em><\/p>\n<p>Imagine you want to create a report data story of energy generation and usage of a country. You\u2019ve collected secondary data from the country\u2019s only power generation company. You intend to extract insights, such as the amount of energy wasted, domestic usage percentage, etc.<\/p>\n<p><em>Let\u2019s use the table below for our scenario.<\/em><\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"123\"><strong>Energy Type<\/strong><\/td>\n<td width=\"90\"><strong>Main Source<\/strong><\/td>\n<td width=\"70\"><strong>Source Type<\/strong><\/td>\n<td width=\"85\"><strong>Energy Source<\/strong><\/td>\n<td width=\"85\"><strong>Usage<\/strong><\/td>\n<td width=\"99\"><strong>End-User<\/strong><\/td>\n<td width=\"95\"><strong>Megawatt<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Losses in process<\/td>\n<td width=\"99\">Lost<\/td>\n<td width=\"95\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Industry<\/td>\n<td width=\"95\">7.3<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; commercial<\/td>\n<td width=\"95\">5.1<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; homes<\/td>\n<td width=\"95\">3.7<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Lighting &amp; appliances &#8211; commercial<\/td>\n<td width=\"95\">4.9<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Agricultural waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Lighting &amp; appliances &#8211; homes<\/td>\n<td width=\"95\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Losses in process<\/td>\n<td width=\"99\">Lost<\/td>\n<td width=\"95\">7.2<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Industry<\/td>\n<td width=\"95\">5.4<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; commercial<\/td>\n<td width=\"95\">6.7<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; homes<\/td>\n<td width=\"95\">4.8<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Lighting &amp; appliances &#8211; commercial<\/td>\n<td width=\"95\">7.4<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Other waste<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Lighting &amp; appliances &#8211; homes<\/td>\n<td width=\"95\">2.5<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Marina algae<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Losses in process<\/td>\n<td width=\"99\">Lost<\/td>\n<td width=\"95\">0.7<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Marina algae<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Industry<\/td>\n<td width=\"95\">0.5<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Marina algae<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; commercial<\/td>\n<td width=\"95\">0.9<\/td>\n<\/tr>\n<tr>\n<td width=\"123\">Marina algae<\/td>\n<td width=\"90\">Bio-conversion<\/td>\n<td width=\"54\">Solid<\/td>\n<td width=\"85\">Thermal generation<\/td>\n<td width=\"85\">Electricity grid<\/td>\n<td width=\"99\">Heating and cooling &#8211; homes<\/td>\n<td width=\"95\">0.5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Follow the <em>simple and easy steps <\/em>below to visualize your data using the \u201cSankey Chart\u201d in the ChartExpo add-in for Excel.<\/p>\n<ul>\n<li>Click on <strong>Add-ins&gt; <\/strong><strong>ChartExpo &gt; Insert &gt; Sankey Chart<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-13.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Select data available in the<\/li>\n<li>Click on <strong>Create Chart From Selection <\/strong>as shown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-14.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Your \u201cSankey Chart\u201d should look like the one below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-15.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>You can add a header, give different colors to nodes, and change different properties ofthe chart by clicking on the <span style=\"font-weight: normal !msorm;\"><strong>\u201c<\/strong><\/span><span style=\"font-weight: normal !msorm;\"><strong>Edit Chart\u201d<\/strong><\/span> button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-16.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<ul>\n<li>Now you will see pencil icons on the screen you can click on any icon to explore and change the properties accordingly.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/how-to-add-excel-add-ins-17.jpg\" alt=\"how to add Excel add-ins\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrUEU2MjQr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytwYitwcGMrUFBDUEJJNjI0K1NhbmtleSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\" https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2023\/10\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\"><\/a><\/div>\n<h2 id=\"remove-add-ins-from-excel\">How to Remove Add-ins From Excel?<\/h2>\n<ol>\n<li><strong>Open Excel Options:<\/strong> Go to the &#8220;File&#8221; menu, click on &#8220;Options,&#8221; and then select &#8220;Add-ins&#8221; from the side menu.<\/li>\n<li><strong>Locate the Add-in:<\/strong> In the Add-ins section, select the type of add-in (e.g., COM Add-ins or Excel Add-ins) from the drop-down menu and click &#8220;Go.&#8221;<\/li>\n<li><strong>Uncheck the Add-in:<\/strong> In the list of installed add-ins, find the one you want to remove, such as ChartExpo or others, and uncheck the box.<\/li>\n<li><strong>Remove or Disable:<\/strong> If applicable, click &#8220;Remove&#8221; to delete the add-in permanently, or simply uncheck it to disable it temporarily.<\/li>\n<li><strong>Restart Excel:<\/strong> Close and reopen Excel to ensure the changes take effect.<\/li>\n<\/ol>\n<h2 id=\"add-excel-add-ins-faqs\">How to Add Excel Add-ins FAQs<\/h2>\n<h3>How do you add Excel Add-ins?<\/h3>\n<ul>\n<li>How to add Excel add-in step-by-step<\/li>\n<li>Click the <strong>File tab<\/strong>&gt;<strong> Options<\/strong>&gt; <strong>Add-Ins category<\/strong>.<\/li>\n<li>In the Manage box, <strong>click Excel Add-ins<\/strong>, and then click <strong>Go<\/strong>.<\/li>\n<li>Select the check box next to the add-in you want to activate in the <strong>Add-Ins <\/strong><strong>Available box<\/strong> and click<\/li>\n<\/ul>\n<h3>What is a Microsoft Excel add-in?<\/h3>\n<p>An add-in is an application that increases more features and options to your Microsoft Excel spreadsheet. By providing additional functions, an add-in increases the <em>power and reliability<\/em> of the tool. Remember to enable your add-in for it to activate when Excel is started.<\/p>\n<h3>How do I enable add-ins in Excel 2016?<\/h3>\n<ul>\n<li>Open a new Microsoft Excel worksheet.<\/li>\n<li>Select File &gt; Options. When the <strong>Excel Options dialog box<\/strong> appears, click <strong>Add-Ins<\/strong>.<\/li>\n<li>In the <strong>Manage drop-down list<\/strong>, click Excel <strong>Add-ins<\/strong> and click <strong>Go<\/strong>.<\/li>\n<li>How to add Microsoft Excel add-ins made easy (using the steps above)<\/li>\n<\/ul>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>As we said, using graph add-ins for Excel will save you hours every day and supercharge your <em>productivity<\/em>. Besides, you\u2019ll access pretty advanced charts and other functions you\u2019ll never find in your beloved spreadsheet app.<\/p>\n<p>How to add Excel add-ins does not have to be a struggle or even time-intensive. This blog is full of tips and strategies you should steal if you\u2019re yet to get started with add-ins.<\/p>\n<p>The Excel add-in we recommend to our readers is ChartExpo because it has a <strong>super-friendly user interface<\/strong>. Besides, it produces charts that are <strong>incredibly insightful and easy to read,<\/strong> even for non-technical audiences.<\/p>\n<p>So whether you\u2019re looking to create a compelling data story or get the most out of your data, ChartExpo add-in has everything you need.<\/p>\n<p><em>Do you want to take your spreadsheet game to the next level? <\/em><\/p>\n<p><strong>Try ChartExpo today<\/strong> to supercharge your productivity and save a ton of time every day.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Click to learn how to add Excel add-ins step by step, plus a different types of visualization examples to take your data storytelling skills to the next level.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/ppcexpo.com\/blog\/how-to-add-excel-add-ins\"><\/a><\/p>","protected":false},"author":1,"featured_media":42839,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[887],"tags":[807],"_links":{"self":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20950"}],"collection":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=20950"}],"version-history":[{"count":15,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20950\/revisions"}],"predecessor-version":[{"id":45352,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20950\/revisions\/45352"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media\/42839"}],"wp:attachment":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=20950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=20950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=20950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}