Latest Blog Posts

How to Change X-Axis Values in Excel (with Easy Steps)

Here is a dataset with the Profit of a company separated by Months that we will use to change X-axis values in Excel. And here is the ...

How to Change Bar Chart Width Based on Data in Excel (with Easy Steps)

We have the following dataset containing 4 groups of students with different weights, and each group contains various numbers of students. We will ...

How to Overlay Line Graphs in Excel (3 Examples)

We will plot the types of graphs from the same dataset, which is below. The dataset includes sales of different stores in different months. All ...

How to Show Legend with Only Values in Excel Chart (with Quick Steps)

Legends are mainly used to denote the data series in an Excel chart for the convenience of our users. Sometimes, we need to show only values in the ...

How to Create Mailing Labels in Excel (with Easy Steps)

We need to create mailing labels in our practical life almost every day. It becomes easier when we use Excel to do this because Excel offers very ...

How to Make a Bar Graph in Excel with 3 Variables (3 Easy Ways)

Looking for ways to know how to make a bar graph in Excel with 3 variables? Sometimes, we use bar graphs to visualize and compare our dataset more ...

Reverse Legend Order of Stacked Bar Chart in Excel (With Quick Steps)

In this article, we will learn to reverse the legend order of a stacked bar chart in Excel. A stacked bar chart is a graph that uses bars to show ...

How to Make a Stacked Bar Chart in Excel (2 Quick Methods)

Basics of a Stacked Bar Chart Bar Chart A bar chart is a diagram where numerical values of variables are shown by the height or the length of the ...

Change Upper Case to Lower Case in Excel: 6 Easy Methods

Method 1 - Applying LOWER Function Type the following formula in cell E5. =LOWER(D5) Press ENTER. Therefore, you will see the ...

Excel Add Line to Bar Chart (4 Ideal Examples)

  Adding a Bar Chart To add a line to the bar chart, we will prepare a dataset with a bar chart first. Insert months and profit amount in ...

How to Stop Auto Capitalization in Excel (with Quick Steps)

Auto Capitalization is often a handy feature of Excel. But sometimes it can be a frustrating thing as Excel does Auto Capitalization by default. In ...

How to Separate an Address in Excel (3 Methods)

Method 1 – Using the ‘Text to Columns’ Option to Split Addresses  The below dataset shows an address 986 Riverview Ct-Xenia, OH, 45385’ in the B5 ...

How to Dynamically Change Excel Chart Data (3 Methods)

Method 1 - Using the INDEX Function In this method, we’ll create a dynamic chart in Excel that allows us to preview product sales amounts for ...

How to Track Changes in Excel with Easy Steps

Method 1 - Turning On Excel Track Changes Go to the File tab. Click the More option if needed to select the Options. Go to ...

How to Convert Qualitative Data to Quantitative Data in Excel

In the following dataset, we have qualitative data for two questions from a survey about people's preferences in movies. We will convert this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo