• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Survey Bar Chart
      • CSAT Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Contact us
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact us
      • FAQs
      • Resources
    • Please feel free to contact us

      atsupport@chartexpo.com

Categories
All Data Visualizations Data Analytics Surveys
Add-ons/
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics Surveys
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok

ChartExpo Survey



Home > Blog > Microsoft Excel

How to Do Sensitivity Analysis in Excel? Easy Steps

This type of analysis entails probing the influence of independent variables on the dependent ones in data.

how to do sensitivity analysis in excel

You can use the technique to easily predict outcomes when an analysis is performed under certain conditions. As an investor, you can easily evaluate all the factors that may negatively affect the growth of your investments using this methodology.

So, how can you establish the relationship between dependent and independent factors in your data?

This is where sensitivity analysis charts, such as the Tornado Graph, come in.

The charts are straightforward to read and interpret. Besides, you can easily integrate them into your data storytelling to cement credibility.

Sensitivity Analysis in Excel cannot be done from its default chart library.

You don’t have to do away with the Excel spreadsheet. Supercharge its usability by installing a particular third-party application into your spreadsheet to access ready-to-use and visually appealing Tornado Charts.

In this blog, you’ll learn the following:

Table of Contents:

  1. Sensitivity Analysis in Excel
  2. Sensitivity Analysis in Excel: Key Purposes
  3. Implementation of Sensitivity Analysis in Excel
  4. Advantages and Weaknesses of Sensitivity Analysis in Excel
  5. How to do Sensitivity Analysis in Excel?
  6. Wrap Up

Sensitivity Analysis in Excel

Sensitivity analysis in Excel determines how different values of an independent variable affect a particular dependent variable under a given set of assumptions.

In other words, how various sources of uncertainty in a mathematical model contribute to the model’s overall uncertainty. This technique is used within specific boundaries that depend on one or more input variables.

Sensitivity Analysis in Excel: Key Purposes

  • Identification of correlations and associations

You can use this insightful chart to uncover hidden correlational relationships in your raw business data.

Interpreting sensitivity analysis in Excel is incredibly easy.

The key to interpreting this chart is to always remember that independent variables (metrics) are found on the horizontal axis (x-axis). And, the dependent variables are situated on the vertical axis (y-axis) in a Cartesian plane.

  • Identification of data patterns and trends

Use a sensitivity analysis Excel chart to identify the general trend of the key variables in your raw data.

Data points in this chart are grouped based on how close their values are, which makes it easier to identify outliers. However, you should be cautious about relying on these outliers for decision-making, as they can contribute to misleading data visualization and may not accurately represent the overall trends.

Interestingly, the nature of the correlations can also be estimated based on a specified confidence level.

  • Display the relationship between two variables

Sensitivity analysis in Excel is widely used by seasoned data visualization experts to display the causal relationships between two variables.

The relationship between variables can be positive or negative.

  • Make reliable forecasts

It can be used to help make predictions about the share prices of public companies.

Some of the variables that affect stock prices include:

  • Company earnings
  • Number of shares outstanding
  • Debt-to-equity ratios (D/E)
  • Number of competitors in the industry

The analysis can be refined about future stock prices by making different assumptions or adding different variables.

This model can also be used to determine the effect that changes in interest rates have on bond prices. In this case, the interest rates are the independent variable, while bond prices are the dependent variable.

How to do sensitivity analysis in Excel should never be time-consuming for you. In the coming section, we’ll address the power of visual analytics and data analysis in economic forecasting and planning.

How to do Sensitivity Analysis in Excel for Decision-Making?

It is used in the business world and the field of economics. Also, it’s commonly used by financial analysts and economists and is also known as a what-if analysis.

Sensitivity analysis in Excel entails probing the relationship between key variables in data

Use sensitivity analysis-based charts to extract relationship insights you cannot see using tables and visualization designs, such as Bar Charts.

Seasoned visualization experts use this analysis mainly to test hypotheses. This occurs during the initial stages of data visualization. If you want to extract micro insights in your bulky data, give this chart a try.

The financial model determines how key metrics are affected based on changes in other factors known as input variables. This model is also referred to as what-if or simulation analysis. It is a way to predict the outcome of a decision given a certain range of variables.

By creating a given set of variables, an analyst can determine how changes in one variable affect the outcome.

Both the target and input or independent and dependent variables are fully analyzed when it is conducted. The person doing the analysis looks at how the variables move as well as how the target is affected by the input variable. For more insights on how to utilize these methods, refer to various visualization story examples that showcase practical applications and outcomes.

In the coming section, we’ll discuss the advantages and weaknesses of doing sensitivity analysis in Excel.

Advantages of doing Sensitivity Analysis in Excel

  • Better decision-making: Sensitivity analysis in Excel helps decision-makers present a range of outcomes to make reliable and data-backed decisions.
  • More reliable predictions: The methodology can help you forecast the performance of the metrics of care most about.
  • Highlights areas for improvement: Doing Sensitivity analysis in Excel can help you identify key areas to make improvements for more profits.
  • Increases credibility: The analysis strategy adds credibility to financial models by testing them across a wide set of key data points.

Weaknesses of doing Sensitivity Analysis in Excel

  • The methodology assumes that key metrics change independently. For instance, material prices change independently of other variables.
  • It only identifies how far a variable can change. So, it doesn’t look at the probability of such a change.
  • It provides information on the basis for making decisions. However, the methodology does not point to the correct decision directly.
  • It considers each variable individually and determines the outcome.

In the real world, all variables are related to each other.

For example, both inflation and market interest rates affect bond prices. Our analysis will consider how much a change in inflation will affect the bond price. And how a change in market interest rate will affect bond prices.

But it won’t consider how a change in inflation will affect the market interest rate or vice versa. This is actually an incomplete analysis.

We’re now at the heart of the blog: How to do Sensitivity Analysis in Excel. You don’t want to miss this.

How to Do Sensitivity Analysis in Excel?

Excel is a trusted data visualization tool because it’s familiar and has been there for decades.

However, the spreadsheet application lacks ready-made sensitivity analysis-based charts, such as the Tornado Chart.

We understand switching tools is not an easy task.

This is why we’re not advocating you ditch Excel in favor of other expensive data visualization tools.

There’s an easy-to-use and amazingly affordable visualization tool that comes as an add-in for Excel which you can easily install in your app to access ready-made sensitivity analysis-based graphs, such as Tornado Graph. The tool is called ChartExpo.

How to make a sensitivity analysis graph in Excel should never overwhelm you. Keep reading to discover more.

So, what is ChartExpo?

ChartExpo is an incredibly intuitive add-in you can easily install in your Excel.

With many ready-to-go visualizations, including butterfly charts, the sensitivity analysis charts generator turns your complex, raw data into compelling, easy-to-digest visual renderings that tell the performance review stories in real time.

  • ChartExpo is cloud-hosted, which makes it extremely light. You have a 100% guarantee that your Excel won’t be slowed down.
  • You can export your insightful, easy-to-read, and intuitive charts in JPEG, PDF, SVG, and PNG formats.
  • ChartExpo add-in is only $10 a month after the end of the trial period.
  • The app has an in-built library with a lot of easy-to-customize and ready-made charts for your data stories.

In the coming section, we’ll take you through how to do sensitivity analysis in Excel using the ChartExpo add-in.

You don’t want to miss this!

Example

This section will use a Tornado Chart (one of the tested and recommended charts for sensitivity analysis).

Risk Low Project
Impact
High Project
Impact
Quality Risk 1742 2000
Legal Risk 1300 1700
Technical Risk 1468 80
Budget Risk 1426 1402
  • To install ChartExpo into your Excel, click this link.
  • Open the worksheet and click the Insert button to access the My Apps option.
insert chartexpo in excel
  • Click the My Apps button and then See All button to view ChartExpo, among other add-ins.
open chartexpo in excel
  • Select ChartExpo add-in and click the Insert button.
  • Once the interface below loads, click the Search box and type your preferred chart.
search chart in excel
  • In this case, type “Tornado Chart” in the Search Box as shown.
create chart in excel
  • Select the sheet holding your data and click the Create Chart from Selection button, as shown above.
  • Check out the final chart below.
tornado chart using sensitivity analysis in excel

Insights:

  • The High Project generally exhibits increased risks in Quality and Legal aspects.
  • Surprisingly, the Technical Risk is significantly lower in the High Project compared to the Low Project, suggesting a more favorable technical environment despite other increased risks.
  • Budget Risk remains relatively consistent between the two project scenarios, with only a slight decrease in the High Project.

FAQs:

Can I visualize Sensitivity Analysis results in Excel?

Absolutely! ChartExpo is an add-in for Excel which allow you to visually represent sensitivity analysis in Excel.

Can you do Sensitivity Analysis in Excel?

Yes, you can perform sensitivity analysis in Excel. It involves changing one variable at a time to see how it impacts the overall result.

Wrap Up

Sensitivity analysis in Excel entails probing the influence of independent factors on dependent factors in data. You can use the technique to easily predict outcomes when the analysis is performed under certain conditions.

So, how can you establish the relationship between dependent and independent factors in your data?

This is where graphs, such as Tornado Graph, come in.

The charts are incredibly easy to read and interpret. Besides, you can easily integrate them into your data storytelling to cement credibility.

Excel does not support sensitivity analysis in Excel default charts library. You actually don’t have to do away with the Excel spreadsheet.

So, what’s the solution?

We recommend you install third-party apps, such as ChartExpo, to access ready-to-use sensitivity analysis graphs.

ChartExpo is an add-in for Excel that’s loaded with insightful and ready-to-go charts, such as Tornado Graph. You don’t need programming or coding skills to use ChartExpo.

Now how to do sensitivity analysis in Excel should never stress you.

Sign up for a 7-day free trial today to access ready-made charts that are easy to interpret and visually appealing to your target audience.

How much did you enjoy this article?

ExcelAd1
Start Free Trial!
120342

Related articles

next previous
Microsoft Excel8 min read

Excel Task Tracker Template for Smarter Task Insights

Task tracker template in Excel organizes tasks, tracks deadlines, and boosts efficiency. Learn its benefits, and explore expert tips to simplify task management.

Microsoft Excel10 min read

Invoice Tracker Template in Excel for Better Insights

An invoice tracker Excel template helps track invoices, due dates, and payments. Learn how to use this template for better financial management.

Microsoft Excel12 min read

Key Performance Indicators in Healthcare for Better Insights

Key Performance Indicators in healthcare track patient care and efficiency. Learn about these KPIs, top examples, and how to use them to improve outcomes.

Microsoft Excel10 min read

BMI Calculation Formula in Excel for Better Fitness Insights

The BMI calculation formula in Excel helps track and analyze body mass index. Explore step-by-step instructions and tips to simplify BMI tracking in Excel.

Microsoft Excel29 min read

How to Create a Tornado Chart in Excel? A Complete Guide

Click to learn how to plot a Tornado Chart in Excel using easy-to-follow steps. Also, we’ll address the following question: what is a Tornado Diagram?

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Survey Bar Chart
  • CSAT Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2025 ChartExpo, all rights reserved.