Excel Charts Archives

How to Calculate Average Tenure of Employees in Excel

Oct 6, 2021 Excel Basics

When you are going to calculate tenure or average tenure, Excel can be a handy tool for you. Today I am going to show you how to calculate average ...

Create a Chart from the Selected Range of Cells (Top 4 Ways)

Sep 8, 2021 Excel Charts 1

Creating charts is one of the main purposes for which you use Excel. The different kind of charts gives us the visual representation of the data we ...

How to add secondary axis in Excel (2 easy ways)

Sep 15, 2021 Excel Charts

In this article, I will show you how to add a secondary axis in Excel charts. Take a look at the following image. Above a regular chart, and below ...

How to Create a Heat Map in Excel (4 Methods)

Sep 15, 2021 Excel Charts 1

Heat maps are the visual representation that shows the comparison of a dataset based on some criteria in a table. In this article, we are going to ...

How to Make a Pie Chart in Excel (Only Guide You Need)

Sep 13, 2021 Excel Charts 1

A pie chart is made of slices that form a circularly shaped graph to represent numerical data of an analysis. Pie charts are difficult to draw as ...

How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel

Jun 4, 2021 Excel Charts

Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are ...

How to Make a Single Line Graph in Excel (A Short Way)

Sep 12, 2021 Excel Charts

In this article, you'll learn how to make a single-line graph in Excel and some other tips related to Excel charting. Line charts are useful for ...

How to Format a Pie Chart in Excel

Jun 5, 2021 Excel Charts

A pie chart is used to showcase parts of a whole or proportions of a whole. There should be about five pieces in a pie chart if there are too many ...

How to Create Combination Charts with a Secondary Axis in Excel

Jun 5, 2021 Excel Charts

When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual ...

What is the Difference Between Bar Graph and Histogram?

Sep 12, 2021 Excel Charts

This is a question that is often asked. What is the difference between a bar graph and histogram and when one should use a bar graph versus a ...

How to make Excel graphs look professional & cool (10 charting tips)

Sep 12, 2021 Excel Charts 2

In this article, Taryn (Our seasoned blogger) has shown how to make Excel graphs/ charts look professional and cool. She has made her charts look far ...

Sparklines in Excel (Insert, Change, & Modify to Show Data Trends)!

Jun 7, 2021 Data Analysis with Excel

It is well known that we can draw a chart easily in Excel. But is it possible to graphically summarize data in a single cell? The answer is ...

How to Make a Control Chart with Excel VBA!

Jun 7, 2021 Excel Charts 4

In this article, I will show you How to Make a Control Chart with Excel VBA. Control charts are widely used to monitor process stability and control. ...

Excel Charts with Dynamic Title and Legend Labels

Apr 6, 2021 Excel Charts

Dynamism is everywhere! Then why not with Excel? Creating dynamic charts in Excel is possible in many ways. What I am going to cover in this ...

Stock return analysis using histograms & 4 skewness of histograms

Jun 7, 2021 Data Analysis with Excel 1

A histogram is a widely used way to summarize a large data set. Creating a histogram using Data Analysis ToolPak is very easy. This blog is aimed to ...