How to Create a Pie Chart in MS Excel

A pie chart illustrates the distribution of your data in the form of a slice in a circle. Each slice represents a percentage of the whole. It means the data in the chart will always add up to 100%. Pie charts use one data series, and display the contribution of each value to a total. 

When to Use a Pie Chart in Microsoft Excel

  • When the data comprises distinctive parts
  • To compare categories
  • To represent percentages at a set point in time
  • To show how 100% divided up into a few shares

You cannot plot a pie chart with continuous data. For example, you cannot plot a pie chart for age, height, and body weight. 

In this pie chart tutorial, you will learn how to make a pie chart in Microsoft Excel. You will also learn to customize the chart, explode or rotate a pie chart, and much more.

So let us get started.

Read more

How to Create a Bar Graph in MS Excel

A bar graph is a visual representation of data using vertical and horizontal bars in a graph. It helps compare data values. You can compare various data sets, survey results, variables, and values. You can also compare the number of trades executed in a day and more. 

Bar graphs show the relationship of the data using the Y-axis (values) and the X-axis (categories). Bar graphs are a commonly used method of data representation by various industries.

When to Use a Bar Graph?

  • To present small data sets 
  • You want to compare different variables and values
  • To display survey results
  • To compare various sets of data
  • To show categories and sub-categories
  • When you have large text labels

In this tutorial, you will learn how to make, sort and customize a bar graph in MS Excel. 

Read more

How to Switch Columns in MS Excel

You may need to switch columns in your MS Excel spreadsheet to re-organize the data. Let us walk you through the methods to swap columns without disturbing your data.

3 Methods of switching columns in Microsoft Excel

  • Cut and Paste Option
  • Drag and Drop Option
  • Duplicate a Column before Swapping

So let’s get started.

Read more

How to Remove a Dropdown List in MS Excel

MS Excel’s dropdown lists are useful for creating quizzes, order forms, surveys, and more. A dropdown list makes data entry easy by making your spreadsheet dynamic. 

The list is a set of predefined values. It provides a simple way to choose from a list of choices. If you no longer need the dropdown list in your spreadsheet, you can remove it. There are several options to remove dropdown lists, which we will explain step by step.

3 Methods to remove a dropdown list in Microsoft Excel:

  • Using Data Validation Dialog Box
  • Using Clear All Button
  • Copy-Paste Option

Let us begin.

Read more

How to Make a Word Cloud in MS Excel

Word Cloud is a visual representation of keywords and tags used in a selection of text. You can use word clouds to show the prominence of some words over others. Typically, words used more often will be bigger than other words in the word cloud in MS Excel.

To create a word cloud you need to install Excel add-ons or use word cloud tools. There are many word cloud generators to choose from. You can choose from free or premium versions. 

Each word cloud generator has its own unique design and customization options. Some of the known word cloud generators are:

  • TagCrowd,
  • MonkeyLearn Word Cloud generator,
  • WordClouds.com
  • Bjorn’s Word Clouds, and more.

In this tutorial, we will use WordClouds.com to generate the word cloud from an Excel file. It is free to use. It offers a variety of themes, formatting options, colors, fonts, sizes, and custom shapes to create impressive word art. 

You can manually edit your word list. Another interesting feature is that you can analyze web pages, by pasting a URL into the source field. Doing so helps you identify the keywords used by your competitors. 

Read more

How to Remove All Hyperlinks in MS Excel

MS Excel inserts a hyperlink when you enter an email address, file location, or website address in a cell. Sometimes these hyperlinks are helpful and sometimes not. Microsoft Excel provides various methods to remove unwanted hyperlinks. We will explain how you can remove all the hyperlinks or groups of hyperlinks.

4 Methods to remove hyperlinks in Microsoft Excel

  • Menu Options 
  • Turn Off Automatic Hyperlink Conversion 
  • Clear Option
  • Select One or More Cells to Remove Hyperlinks

We will also explain how to edit existing hyperlinks.

Let us begin.

Read more

How to Create a Scatter Plot in MS Excel

A scatter plot in MS Excel is also known as an XY chart. A Scatter plot represents the relationship between two separate sets of numbers. 

The horizontal and vertical axis comprises numerical data only, but can also represent date values. The data in the left column appears on the X-axis and the data in the right column appears on the Y-axis. 

When to use a scatter plot:

  • With two sets of numerical data.
  • To determine the relation between the two variables.
  • To include date and hour values in your source data.
  • To show a non-linear pattern.

This tutorial will guide you through the steps to create and customize a scatter plot in Microsoft Excel.

Read more

How to Create a Line Chart in MS Excel

A line chart in MS Excel contains two or more individual data points connected by lines. The data points represent a series of information. It explains the relationship between the X-axis and the Y-axis on the graph. A line chart is ideal for describing the relationship between two entities. For example – Sales and Demand or Profit and Loss. 

Line charts are easy to read. It distributes the category data along a horizontal axis and the numerical value along the vertical axis. 

When to Use a Line Chart? 

The line chart is a simple chart. It is crucial to understand when to use it efficiently to display your data. Use a line chart when you want to:

  • Display trends in your data at regular intervals or over time. 
  • Your data has non-numeric values.
  • Use text to display values like months, quarters, or years.
  • Use numerical labels to display a time interval like years.
  • Display time scales like the number of days, months, and years. 

Read more