# Category Archives for "Charting"

## 5 How to Create a Dynamic Chart Range in Excel

When you create a chart in Excel and the source data changes, you need to update the chart’s data source to make sure it reflects the new data. In case you work with charts that are frequently updated, it’s better to create a dynamic chart range. What is a Dynamic Chart Range? A dynamic chart […]

## How to Make a Bell Curve in Excel (Step-by-step Guide)

A bell curve (also known as normal distribution curve) is a way to plot data that looks like a bell curve. In the bell curve, the highest point is the one that has the highest probability of occurring, and the probability of occurrences goes down on either side of the curve. It is often used during […]

## How to Quickly Copy Chart (Graph) Format in Excel

Watch Video – Copy Chart (Graph) Format in Excel When you work with Excel charts, it rarely happens that you use the same default chart that Excel creates for you. In most of the cases, you have to change it’s formatting based on your brand, project, or audience. Now, if there is a fixed format […]

Excel Dashboards can be very useful when you need to assess the performance of some key metrics over a period of time. This Call Center Performance Dashboard enables the user to analyze the performance on a weekly basis and track key call center metrics. Call Center Performance Dashboard Here’s a how the dashboard looks: Click […]

## 4 How to Make a Histogram in Excel (Step-by-Step Guide)

A histogram is a common data analysis tool in the business world. It’s a column chart that shows the frequency of the occurrence of a variable in the specified range. According to Investopedia, a Histogram is a graphical representation, similar to a bar chart in structure, that organizes a group of data points into user-specified ranges. The […]

## 6 How to Quickly Create a Waffle Chart in Excel

Have you heard of the Waffle Chart (also called the square pie chart)? I have seen these in a lot of dashboards and news article graphics, and I find these really cool. A lot of times, these are used as an alternative to the pie charts. Here is an example of a waffle chart (shown below): […]

## 15 Step Chart in Excel – A Step by Step Tutorial

Watch Video – Creating a Step Chart in Excel A step chart can be useful when you want to show the changes that occur at irregular intervals. For example, price rise in milk products, petrol, tax rate, interest rates, etc. Let’s take an example of Petrol hike in India. It can happen any day (as decided […]