Latest Blog Posts

How to Add a Marker Line in an Excel Graph (3 Suitable Examples)

  Example 1 - Adding a Marker Line in a Line Chart Steps: Select cell D5 and enter the following formula: ...

Create a Bubble Chart in Excel with Multiple Series: 7 Easy Steps

Method 1 - Insert Bubble Chart with Multiple Series in Excel Select any cell. Go to the Insert tab. Select Insert Scatter (X, Y) or Bubble ...

How to Reorder the Legend Without Changing the Chart in Excel

Step 1 - Add Dummy Values to Dataset Add dummy values to your dataset. Suppose you have a dataset with a chart whose legend you want to ...

How to Change Bar Chart Color Based on Category in Excel (3 Methods)

In the dataset, we have sales and profit information about some products. Here, the negative profit of a product refers to the loss in sales of that ...

How to Create a Pie Chart in Excel from a Pivot Table (2 Methods)

What is a Pie Chart? A Pie Chart is a circular graph where each slice represents a proportionate part of the entire dataset. In Microsoft Excel, ...

How to Add a Vertical Line to a Scatter Plot in Excel – 2 Methods

This is the sample dataset. Method 1 - Using Error Bars to Add a Vertical Line to a Scatter Plot in Excel Steps Select B5:C11. ...

How to Create Curved Labels in Excel Doughnut Chart (With Easy Steps)

We will use a dataset that contains information on the Sales Amount of the first six months of a company. We will plot the data on a doughnut chart ...

How to Create a Polynomial Trendline in Excel – 2 Methods

In the dataset below, the Total Revenue amounts depend on multiple conditions. To insert a polynomial trendline:   Polynomial and ...

SBI Home Loan EMI Calculator in Excel Sheet with Prepayment Option

    What Is Home Loan EMI? EMI stands for Equated Monthly Installment. It includes repayment of the principal amount and payment of ...

Excel Doughnut Chart with Multiple Rings (Create with Easy Steps)

Here's an overview of a doughnut chart with multiple rings, outlining sales data in different quarters. How to Create a Doughnut Chart ...

How to Add a Legend in Excel (2 Methods)

In the below example, the Legend is marked by the red outlined box. The Blue color represents Sales and the Orange color represents Profit. ...

Excel VBA: If Statement Based on Cell Value: 2 Practical Methods

Method 1 - If Statement Based on Cell Value of a Single Cell in Excel VBA We’ll learn to use an If statement based on the value of a single cell. ...

How to Show Data Labels in Excel 3D Maps: 2 Methods

Create a 3D Map in Excel Steps: Select any cell within the dataset. We selected cell D6. From the Insert tab >>> select 3D Map. ...

How to Group Small Values in an Excel Pie Chart (2 Methods)

Method 1 - Group Small Values with Pie of Pie Chart Prepare Your Data Input the names of the 12 months in cells B5:B15. Enter the total ...

How to Explode a Pie Chart in Excel – 2 Methods

  This is the sample dataset. This is the corresponding pie chart: Method 1 - Exploding a Pie Chart Using the Mouse ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo