# Tag Archives for " Excel Charting "

## 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 […]

## 13 KPI Dashboard in Excel [Part 3 of 3] – Extract List of Companies from the Scatter Chart

This is the third and final article of the three-part tutorial series on Creating a KPI Dashboard in Excel. Part 1: Creating a Dynamic Scatter Chart in Excel Part 2: Spotting the Data Point and Creating a Dynamic Interpretation for the Chart Part 3: Extract List of Companies from the Scatter Chart + Company comparison( using […]

## 5 KPI Dashboard in Excel [Part 2 of 3] – Dynamic Interpretation from Scatter Chart

This tutorial is a part of a three part Excel KPI Dashboard tutorial series: KPI Dashboard in Excel – Part 1: Dynamic Scatter Chart. KPI Dashboard in Excel – Part 2: Dynamic Interpretation. KPI Dashboard in Excel – Part 3: Dynamic Data Extraction + Bullet Chart. In the previous article of this 3 part ‘KPI […]

## 22 KPI Dashboard in Excel [Part 1 of 3] – Dynamic Scatter Chart

Watch Video – Creating KPI Dashboard in Excel – Part 1/3 Learn the exact steps I take to create World Class Dashboards in Excel. Join the Excel Dashboard Course. A Key Performance Indictors (KPI) dashboard is one of the most used dashboards in business. Its primary objective is to show the performance of key KPIs and provide […]

## 5 How to Create Dynamic Chart Titles in Excel

Do you suffer from Forgot-to-change-chart-titles syndrome? I do. Worry not. Today’s prescription includes an article and a video on how to create dynamic chart titles in excel. Linking a Cell Value to the Chart Title Suppose you have the data as shown below and you have created a chart using it. If you want to […]

## 7 Dynamic Charting – Highlight Data Points in Excel with a Click of a Button

A chart gets difficult to read if it has a lot of data plotted on it. While it is a good practice to plot only the relevant data, there are situations where you need to show a lot of data points on a single chart. If you are stuck in such a situation, it is a good […]

## 7 A Step-by-step Guide on Creating a BULLET Chart in Excel

One of the challenges while creating a dashboard is to present the analysis in a limited screen space (preferably a single screen). Hence, it is important to make smart choices while creating the right chart. And here is where Bullet Charts score over others. Bullet charts were designed by the dashboard expert Stephen Few, and […]