Latest Blog Posts

How to Create Excel Gantt Chart with Multiple Start and End Dates

  What Is a Gantt Chart? The Gantt chart was popularized by Henry Gantt. It is a type of bar chart that illustrates or tracks a project ...

How to Use Win Loss Sparklines in Excel (2 Easy Ways)

Sparklines show data patterns in a single cell in Excel. There are 3 types: Line, Column, and Win/Loss. These are a type of Column Chart showing only ...

How to Make a Price Comparison Chart in Excel – 3 Examples

How to Make a Price Comparison Chart in Excel: 3 Examples   This is the sample dataset, containing product prices for different months and ...

How to Create a Progress Bar in Excel (3 Easy Methods)

Suppose we have a dataset of a company’s year-wise Forecasted Sales and Actual Sales. We will create a progress bar graphing both the Forecasted ...

How to Create a Clustered Column Pivot Chart in Excel: 3 Easy Steps

Method 1 - Create a Pivot Table from Dataset Create a pivot table to reach the final destination. Select all the cells from the data table ...

How to Make a Vertical Waterfall Chart in Excel (with Easy Steps)

Introduction to a Vertical Waterfall Chart A waterfall chart is a graph that displays the original value, the values that have been added to it or ...

How to Show Dependencies in an Excel Gantt Chart (2 Easy Methods)

In the below dataset, we have some tasks along with their Proposed Start Date and End Date. Due to the dependencies, the proposed start dates are ...

The Excel Chart is Not Updating – 2 Solutions

Observe the following dataset and the corresponding chart. It’s a 100% stacked chart of 3 stores’ sales data.   Reminder: If ...

How to Calculate Share Price Volatility in Excel (2 Easy Methods)

It‘s mandatory to calculate share price volatility while you are going to invest in the share market. It will help to determine the risk. In Excel, ...

How to Calculate the EMI in Excel – 2 Methods

What Is the EMI? Equated Monthly Installment, or EMI, is a fixed amount that a borrower must pay a lender on a monthly basis. What Is an EMI ...

How to Add a Target Line to a Pivot Chart in Excel (2 Effective Methods)

The dataset contains sales information about some grocery items. We will show you how to add this amount as a target line in a Pivot Chart. ...

How to Make a Pie Chart in Excel with Words (with Easy Steps)

Step 1 - Arranging the Dataset for a Pie Chart in Excel Insert the data you need to plot in the chart. We'll use a list of employees and their ...

How to Edit the Legend of a Pie Chart in Excel (3 Methods)

About the Pie Chart Legend A legend represents entries that correspond to the data displayed in the plot area of a chart. Most Excel charts include ...

How to Create a Stacked Waterfall Chart in Excel – 3 Steps

The following dataset contains records of price changes of product “X” from 2015 to 2021. A stacked waterfall chart will show the changes over the ...

How to Change Axis Titles in Excel (with Easy Steps)

In our daily life, we deal with lots of graphs and charts. Sometimes we feel the necessity of changing the axis titles of the graphs and charts ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo