Latest Blog Posts

How to Make a Bar Graph in Excel with 4 Variables (with Easy Steps)

Step 1 - Insert Data for Bar Graph We will insert data for the Week and the Sales columns. Select Range B5:C9. Go to the Insert tab. ...

How to Create a Bubble Chart in Excel with Labels (4 Easy Ways)

Looking for ways to know how to create a bubble chart in Excel with labels? Usually, we use bubble charts to graphically visualize multiple numerical ...

How to Make a Diverging Stacked Bar Chart in Excel (with Easy Steps)

Consider a sample dataset with the top 5 most popular U.S. mobile network operators and their customer reviews. We will present them in the form of a ...

How to Create a Chart Legend in Excel (a Detailed Analysis)

  What is a Chart Legend A Chart Legend can be defined as representing a data series on a chart. For example, when you have several columns of ...

How to Create a Distribution Chart in Excel: 2 Methods

Method 1 - Creating a Frequency Distribution Chart in Excel Let’s say we have the information for Oakmont Ridge Golf Club shown in the B4:C14 cells ...

Excel Stacked Bar Chart with Subcategories: 2 Methods

Method 1 - Using Stacked Bar Chart Feature to Create Excel Stacked Bar Chart with Subcategories Steps: Select the dataset. Go to the Insert ...

How to Change Bubble Size in Scatter Plot in Excel (with Simple Steps)

We will use this sample dataset to plot a Scatter Chart.   Step 1 - Insert Scatter Plot Select cells in the B4:C10 Go to ...

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

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

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

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

The Waterfall Chart Total is Not Showing – 3 Solutions

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

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

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 Create a Gantt Chart for Multiple Projects in Excel

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo