Excel Charts

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

Excel Chart Bar Width Too Thin (2 Quick Solutions)

The following table has the Date and Sales columns. We will use these columns to insert a Column Chart. Since the Date column has dates in it, which ...

How to Make a Pie Chart with Multiple Data in Excel (2 Ways)

Let’s consider sales of flowers at a shop. With the help of a pie chart, we can show the sales of different flowers graphically. Note: One ...

How to Add Milestones to Gantt Chart in Excel (with Quick Steps)

What Is a Gantt Chart? A Gantt Chart is a graph that generally shows the relationship between tasks or milestones and time. It is a very useful tool ...

How to Make a Scatter Plot in Excel with Multiple Data Sets (2 Methods)

Method 1 - Using Multiple Data Sets from the Same Chart Steps: Select the entire dataset. Go to the Insert tab of the ribbon. From ...

How to Make Multiple Pie Charts from One Table (3 Easy Ways)

Here, we have a dataset containing the sales data of 5 shops for three consecutive months: January, February, and March. We will use this dataset to ...

How to Change Color Based on Value in Excel Doughnut Chart

STEP 1 - Input Data Input the dataset. In this example, we’ll consider a Profit percentage of a product. STEP 2 - Set up the Data ...

How to Insert a 3D Clustered Column Chart in Excel: 5 Methods

Method 1 - Arrange Dataset for 3D Clustered Column Chart Here's a dataset of people with their Work Hours in Column C and Daily Pay in Column D. You ...

How to Make a Line Graph in Excel with Two Sets of Data

We have two datasets. One set contains Sales and Profit for Texas and the other one contains Sales and Profit for Missouri. We will be making a ...

How to Create Dynamic Charts in Excel Using Data Filters – 3 Easy Methods

The following dataset will be used to create dynamic charts in Excel using data filters. Method 1 - Filtering the Dataset to Create ...

How to Plot an Excel Chart by Month and Year (2 Examples)

Below is a dataset for the Monthly Sales Quantity of 6 months, consisting of Date and Sales columns. Method 1 – Using a Single Legend Entry ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo