Latest Blog Posts - Page 301 of 584

Excel VBA: Get Source Data Range from a Chart (with Quick Steps)

Nov 11, 2025

In this article, I’ll show you how you can get the source data range from a chart using VBA in Excel. Excel VBA: Get Source Data Range from a ...

Excel VBA: Get Source Data Range from a Chart (with Quick Steps)

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

Jul 3, 2024

What Is a Pie of Pie Chart? Pie of Pie Chart is a Pie chart under which there will be a secondary Pie chart. The Pie of Pie chart separates some ...

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

The Waterfall Chart Total is Not Showing – 3 Solutions

Aug 10, 2024

The dataset below showcases the June 2022 monthly transaction. Using the data above, a Waterfall Chart was created ( Insert > Charts ...

The Waterfall Chart Total is Not Showing – 3 Solutions

How to Plot Time over Multiple Days in Excel (With Easy Steps)

Nov 11, 2025

Excel is a very powerful software. We can perform numerous operations on our datasets using Excel tools and features. With the help of various charts ...

How to Plot Time over Multiple Days in Excel (With Easy Steps)

How to Create a Gantt Chart for Multiple Projects in Excel

Jul 15, 2024

Step 1 - Prepare Your Dataset In the following image, we can see the basic outlines of the dataset. Project Name: Enter the name of each ...

How to Create a Gantt Chart for Multiple Projects in Excel

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

Apr 23, 2024

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 Create Excel Gantt Chart with Multiple Start and End Dates

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

Nov 11, 2025

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 Use Win Loss Sparklines in Excel (2 Easy Ways)

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

Aug 3, 2024

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)

Jun 15, 2024

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 Progress Bar in Excel (3 Easy Methods)

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

Jun 22, 2024

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 Create a Clustered Column Pivot Chart in Excel: 3 Easy Steps

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

Jul 29, 2024

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 Make a Vertical Waterfall Chart in Excel (with Easy Steps)

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

May 11, 2024

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 ...

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

The Excel Chart is Not Updating – 2 Solutions

Aug 4, 2024

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

The Excel Chart is Not Updating – 2 Solutions

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

Nov 11, 2025

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 Share Price Volatility in Excel (2 Easy Methods)

How to Calculate the EMI in Excel – 2 Methods

Aug 4, 2024

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 ...